| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to count zeros and not blank in selected range?
Hi
Well I have some data in which i wish to count number of "0" in the selected column or row. I tried out some simple 'If' formula as "=IF(U8=0,1,0)" but it does not work when the cell is blank. It displays 1, I was going to use the sum function to make total of one. Also This formula works only for one cell and not for the range(column or Row), can u help me out for the range. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell is blank then dont count range | Excel Discussion (Misc queries) | |||
| How do I set an average to not count blank cells as zeros? | Excel Worksheet Functions | |||
| How can I use €ścountif€ť to count BOTH zeros AND blank cells as zer | Excel Worksheet Functions | |||
| Need assistance: Count non-blank within date range | Excel Worksheet Functions | |||
| I want blank cells, but they're all zeros now that I have formatted them | Excel Discussion (Misc queries) | |||
Threaded Mode
