| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is it possible to total multiple cells with an "IF" function value
I am having trouble figuring out how to create a formula to add multiple
cells (not all in the same column or row). The value of these multiple cells are populated based on the "IF" function I've entered. i.e.: =IF(B4="Package 1","75,000","") When the field populates with 75,000, excel doesn't seem to recognize it as a number value since there is a formula in that field. Since excel isn't recognizing it as a value, I am unable to create a formula that will sum these multiple cells. That is my guess on what the issue is. My question is can you add (SUM) cells that are populated based on an "IF" formula in that cell? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| "Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
| SUM Calculations Returns #VALUE but displays correct total with "Insert Function"=fx | Excel Worksheet Functions | |||
| How to total rows in Excel with non-value cells like "included"? | Excel Worksheet Functions | |||
| Linking two "total" pages to create a "Complete Total" page | Excel Worksheet Functions | |||
Threaded Mode
