| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF absolute value of cells in a range are 0
How would I use COUNTIF to count only those cells whose absolute values are
greater than 0? This is my formula: =SUM(H5:H103)/COUNTIF(H5:H103,"0") But there are negative numbers in the range which should be counted as well as the positive numbers. I only want to exclude 0 values. Thanks, Dave -- Brevity is the soul of wit. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cells from named range | Excel Discussion (Misc queries) | |||
| COUNTIF in a range (and parts of cells) | Excel Worksheet Functions | |||
| UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) | |||
| Select Range of Cells | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Threaded Mode
