Question about Computers & Internet
I want to be able to add a value from cell "a" to cell #1 only if cell #2 contains a value or text, then I want to add a second value from cell "b" to cell #1 only if cell #3 contains a value or text, finally, when cell #4 contains a value or text I want cell #1 to drop the values in cells "a" & "b" and add the value in cell "c". Can I do this using if and then?
Try using the SUMIF function for one condition or multiple conditions. Use the SUMIF worksheet function to create a total value for one range based on a value in another range. For example, for every cell in the rage B5:B25 that contains the value "Northwind", the following formula calculates the total for the corresponding cells in the range F5:F25. Formula:
Here are SUMIF functions for multiple conditions.
Also check your help for SUMIF functions.
If this helps you, Please rate me. Thanks, Patty
Posted on Dec 30, 2007
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Jul 03, 2017 | The Computers & Internet
Oct 31, 2008 | Computers & Internet
Sep 07, 2014 | Microsoft Excel for PC
Oct 26, 2010 | Texas Instruments TI-30XA Calculator
Jul 21, 2009 | Microsoft Office Excel 2007
May 28, 2009 | Adobe Flash® CS3 Professional Full Version...
May 23, 2009 | Computers & Internet
Dec 03, 2007 | Microsoft Excel for PC
Sep 15, 2007 | Microsoft Office Standard for PC
153 people viewed this question
Usually answered in minutes!