| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement / Array
Hello,
I have data in columns A, B, and C. In column D, I would like a formula that sums the contents of A1:C1, but only if none of the cells contains a zero. In other words, if all the cells are greater than zero, return the sum. If one of the cells has a figure of zero, return zero. Help?! TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement with 2 array formulae | Excel Worksheet Functions | |||
| Array, Formula, Constant, IF Statement Question???? | Excel Discussion (Misc queries) | |||
| IF statement in Array Formula's | Excel Discussion (Misc queries) | |||
| Searching for a criteria in array of cells within an IF statement | Excel Worksheet Functions | |||
| Array If statement doesn't work | Excel Worksheet Functions | |||
Threaded Mode
