| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif Cells Are Not Blank
I'm looking to total a range of cells ONLY if they have a value of 0 or more
entered in them. In plain english: Sumif A1 is =0 Sumif A2 is =0 Sumif A3 is =0 and so on. Where every cell in the range must have a value of 0 or more entered before the function will return a result. How do I do this? Thanks, PO |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| Checking Blank Cells | Excel Worksheet Functions | |||
| pivot tables reports - altering display of (blank) cells | Excel Worksheet Functions | |||
| Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
| Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
Threaded Mode
