Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding cells that have varying contents
Have a group of cells in a row that all contain similar formulas.
They look like: =IF(T17="","",T17*($M17/$N17)) or, =IF(U17="","",U17*($M17/$N17)) I want to add up the results of their formulas, including the cells that have returned blanks. If 8 columns have this (or similar) formula, and only 2 display numbers, how can I return a true sum, that is not" #VALUE" as a total for that row? TIA for any help. Pierre |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying cells from varying rows | Excel Discussion (Misc queries) | |||
concatenate with a varying range of cells | Excel Worksheet Functions | |||
compare the contents of one range of cells with the contents of a. | Excel Discussion (Misc queries) | |||
Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) |