Question about Computers & Internet
I have a spreadsheet with multiple sheets that i need to calculate using the sumifs funtion
Here is the syntax: =SUMIF(Sheet2!A1:A3,"> 1", Sheet2!B1:B3)
This says if the cells A1 through A3 in worksheet "Sheet2" are greater than 1 then return the values from worksheet "Sheet2" cells B1 through B3.
Change the worksheet name Sheet2 to your worksheet name and change the cell references to the ones you need.
Posted on Aug 21, 2009
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
New users get to try the service completely Free afterwhich it costs $6 per call and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jul 29, 2009 | Computers & Internet
May 07, 2009 | Microsoft Excel 2007 Home and Student...
Apr 11, 2009 | Microsoft Works 8.0 for PC
Jun 27, 2008 | Microsoft Excel for PC
Apr 09, 2008 | Microsoft Excel for PC
Apr 04, 2008 | Microsoft Excel for PC
Dec 09, 2007 | Computers & Internet
Sep 05, 2007 | Microsoft Office Standard for PC
172 people viewed this question
Usually answered in minutes!