find an average from a range, utilizing all data 0
Hi!
Try one of these:
=SUMIF(A1:G1,"0",A1:G1)/COUNTIF(A1:G1,"0")
This one is an array and must be entered using the key combo of
CTRL,SHIFT,ENTER:
=AVERAGE(IF(A1:G10,A1:G1))
Biff
"Chase" wrote in message
...
I have a row of various #s and I would like to take the average of those
numbers only if they are greater than 0, if they are less than or equal to
0
I would like to omit them.
How can create a formula to reflect this?
Thanks,
CT
|