Count non-zero numbers only

[loudnoiseman]

Hi Everyone,

I'm trying to figure out how to make the count formula only account for numbers above or below zero but not zero itself.

For my purposes each instance where there is a zero essentially is not a factor to be considered yet it is factored in and thus throws off my expected result.

As an example, a range of cells containing 1 through 10 averages 5.5 but if I replace 3 & 7 with 0 then the average changes to 4.5 but if I deleted 3 & 7 then it's 5.625

Thanks!

 

[JoeMo]

Book1
	A	B	C	D
1	7		20	18
2	1
3	-5
4	10
5	-3
6	-10
7	4
8	0
9	-7
10	3
11	-1
12	7
13	5
14	7
15	0
16	9
17	10
18	2
19	-2
20	7
ListNamedRanges

Cell Formulas
Range	Formula
C1	C1	=COUNT(A1:A20)
D1	D1	=COUNTIF(A1:A20,"<>0")

 

[loudnoiseman]

Nice, JoeMo thanks!

 

[JoeMo]

Nice, JoeMo thanks!

You are welcome - thanks for the reply.