Question about Business & Productivity Software
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
Tips for a great answer:
Sep 07, 2014 | Microsoft Excel for PC
Apr 25, 2014 | Microsoft Excel for PC
Jul 21, 2009 | Microsoft Office Excel 2007
May 28, 2009 | Adobe Flash® CS3 Professional Full Version...
Feb 27, 2009 | Microsoft Office Standard for PC
Nov 13, 2008 | Business & Productivity Software
Apr 13, 2008 | Business & Productivity Software
Dec 03, 2007 | Microsoft Excel for PC
Oct 01, 2007 | Microsoft Office Standard for PC
Sep 15, 2007 | Microsoft Office Standard for PC
Oct 20, 2016 | Intuit QuickBooks Business & Productivity...
144 people viewed this question
Usually answered in minutes!