| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Problem requiring help
Hi all
What I am trying to achieve is to sum each cell in my range that has a value either 0 or 1, but if a cell is "", then don't sum those cells. =Sum($B$7:$B$10,$I$6,$I$8:$I$10,$P$6:$P$7,$P$9:$P$ 10,$W$6:$W$8,$W$10,$AD$6:$AD$9) Tried this but am wrong =Sum(Product($B$7:$B$10,$I$6,$I$8:$I$10,$P$6:$P$7, $P$9:$P$10,$W$6:$W$8,$W$10,$AD$6:$AD$9,<0),"") Need some guidance please. TIA Mark. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Requiring data in certain cells | Excel Worksheet Functions | |||
| Excel start-up requiring Frontpage disk? | Excel Discussion (Misc queries) | |||
| requiring a field | Excel Worksheet Functions | |||
| Formulas requiring a time stamp | Excel Worksheet Functions | |||
| Formula requiring two different criterias | Excel Worksheet Functions | |||
Threaded Mode
