Using Google Sheets with the expression SUMIF, is there a way to make the criteria field look for 2 types of values using OR logic? A BJoe 1Joe 2Tim 3Roy 4Tim 5Roy 6How do I make a SUMIF to the rows for Joe and Roy so the result is 13? Basically I want it to sum only when cells in A are Joe OR Roy. ...

Thanks for taking the time to view my question, I have been searching for hours (no joke) to have no avail. I got on my computer and decided to make Kali Linux bootable since Virtual Box had tooo much lag. I got my Kali Iso and bu ed it to my flash drive with Win32DiskImager. Also since I wanted per...

I have added a path to a DLL file's location (FrameStream.dll) to my System Variable on a Windows XP machine, but when I run an application that loads the said DLL file, an error message tells me that it is not found. This is the entry of my System variable Path: %SystemRoot%system32; %SystemRoot%; ...

My network setup: WAN > Router(pfsense) > AP(tomato) The gateway for my router is 10.12.1.1 The gateway for my AP is 10.12.1.201 My AP is only an AP, not a DHCP server. The router is my DHCP server. What I'm trying to do is create a new bridge(br1) on my AP, to assign it to a VLAN. Well I need to gi...

normally i'd just use imagemagick's convert, but I had a bunch of sca ed images that i had to crop the content which was all over the place. So i opened some 30 images on gimp, manually cropped them all. Now I found myself wanting to resize them to 66% of the size and export them all to their origin...

I installed transmission-daemon by follow a tutorial, and s3fs as its completed folder. At first, it came a error about failed to set buffer, after I search over web and disable the utp, but it started to fail with another reason. sudo service transmission-daemon status give me the following error: ...

and sorry for bothering you, I have just bought an MSI PE60. I have installed Windows 10 in Legacy boot mode, so I have to install Ubuntu in Legacy mode, too. I want to install Ubuntu with the Live USB. So far, I have tried with the 15.10 version and the 16.04 beta version, but the problem is always...

For some time now I've been using this script to view my login time for a particular computer: Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.GetFile("C:Windowssetupact.log") Wscript.Echo "Log on today at " & FormatDateTime(objFile.DateLastModified,vbShortTime) This is ...

This is my first time on these forums so if I do something wrong please correct me, So I am following this tutorial on how to install metasploit: http://hackerforhire.com.au/installing-metasploit-framework-on-os-x-el-capitan/ but after doing initdb on postgresql, typing postgres into terminal compla...

Find out and display the total amount of TTT substrings found in the first 2,000 lines in the file. I had using grep until I tested it and realized it does not identify substrings. Help!!!

I have a Proxmox server ru ing several containers, some with exte al and inte al networks, some with only inte al. The Proxmox server itself has OpenVPN server installed on it, and I can co ect to it and ping/traceroute the server itself, as well as containers with only an inte al network. However, ...

I have a bare git repository on my Raspberry Pi which only I use. When pushing to it today, I got this error message: Counting objects: 460, done. Delta compression using up to 8 threads. Compressing objects: 100% (367/367), done. remote: fatal: pack has bad object at offset 1641: inflate retu ed -5...

I have multiple large zip files and I would like to recompress them without unpacking them (I run the risk of ru ing out of disk space). I am thinking of using advzip for that task. However, I want to ensure that the compressed data is not corrupted in the process. How can I do that? Obviously, hash...

I got a new laptop with Windows 10 about a month ago, and I installed Corel PaintShop Pro X6, which lists Inte et Explorer as its default Inte et browser. I added Google Chrome as an alte ate browser, but when I try to point to Microsoft Edge as either an alte ate or default browser, PSP tells me it...

How does ssh-agent understand which key should it use for which remote server? I've came across different questions and posts that touches this topic somehow, but it still remain unclear to me. What I have found is that if you want to use different ssh keys you need to use -i option and specify path...

To test our software with some real-world data, I want to download lots and lots of files of a specific type (say, PDF or doc). I could manually google and use some download manager extension for my browser, and have in fact done just that, but it doesn't really scale. Is there a way to automate thi...

I have a spreadsheet for calculating attendance % based on the last 24 weeks. So I have a cell with today's date, and I use this to find the index of the cell with the closest previous date, simple enough so far.... What I'd like to do is sum up the total of the previous 24 columns. So currently I'm...

I have several thousand hostnames in a list. Some of these names are FQDN, and some are hostname only. How can I identify duplicates in this situation? HostABC HostABC.domain.com These are the same host, just one is fully qualified and one is not.

I work in the Auto Industry where I have to create a Pivot Table based on Auto information each month. The Sort Order of the Pivot Table needs to be Model Series Door Cylinder Model ID Code Trim Level Transmission Color This is the order of sort if the data is sorted through Excel because it allows ...

What is Word's nonprinting symbol that is a small circle (looks like a "degrees" mark)? I haven't found this in other articles, web searches, forums. Is it a new version of "keep with next"? This comes up regularly when copy/pasting from a gmail draft into Word for the purpose of fixing formatting (...