Thread
:
How to average a column of numbers that are greater than 0?
View Single Post
#
10
Posted to microsoft.public.excel.worksheet.functions
Sasa Stankovic
external usenet poster
Posts: 27
How to average a column of numbers that are greater than 0?
because I don't like array functions... it is not something special... I
just dont like to use them...
"Don Guillett" wrote in message
...
why?
--
Don Guillett
SalesAid Software
"Sasa Stankovic" wrote in message
...
I support this result as the most logical....
"bpeltzer" wrote in message
...
I'll admit my bias against array formulas and offer an alternative...
Average is simply sum/count. So =sumif(range,"0")/countif(range,"0")
will
average the positive values.
"JimNColorado" wrote:
I am trying to average a column of numbers. I want to only average the
cells
that contain a number greater than 0. How do I do that?
Reply With Quote
Sasa Stankovic
View Public Profile
Find all posts by Sasa Stankovic