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
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.
The service is completely free 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 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!
Step 2: Please assign your manual to a product: