Thread
:
How to average a column of numbers that are greater than 0?
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
How to average a column of numbers that are greater than 0?
this is an array formula that must be entered/edited using ctrl+shift+enter
=AVERAGE(IF(E1:E210,E1:E21))
--
Don Guillett
SalesAid Software
"JimNColorado" wrote in message
...
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
Don Guillett
View Public Profile
Find all posts by Don Guillett