| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count IF omitting blank or zeroes
I am sure this was posted before. What I want is be able to count cells that have numbers only excluding zeroes and blank cells. -- Ash |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count IF omitting blank or zeroes
Try...
=COUNT(A2:A100)-COUNTIF(A2:A100,0) Hope this helps! In article , Ash wrote: I am sure this was posted before. What I want is be able to count cells that have numbers only excluding zeroes and blank cells. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count IF omitting blank or zeroes
=COUNTA(range)-COUNTIF(range,"=0") There's probably a way to do it without any need for a subtraction, but this does work. -- Spreadsheet ------------------------------------------------------------------------ Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730 View this thread: http://www.excelforum.com/showthread...hreadid=556693 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
| enter numbers in blank cells | Excel Worksheet Functions | |||
| Count Non Blank in column | Excel Discussion (Misc queries) | |||
| Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
| count non blank cells which meet criteria in another column | Excel Worksheet Functions | |||
Hybrid Mode
