Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT NON-CONTINOUS CELL
I want ot enter a formula in cell A20 which should be the sumproduct of range
A1 to A19 & of coloumn B1 to B19 but to exclude some cells from both coloumns, conditionality being if there are no figures in any of the cell (cell value being 0). Thus if cell A5=0, to ignore both cell A5 & B5. pL help. Thanks in anticipation |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Continous number box | Excel Discussion (Misc queries) | |||
Sum of continous cell | Excel Worksheet Functions | |||
Print row labels that are continous | Excel Discussion (Misc queries) | |||
Continous updating of linked spreadsheet | Links and Linking in Excel | |||
countif with non-continous ranges | Excel Worksheet Functions |