Exclude Zero Values from Average?

K

Ken

Excel 2000 ... How do I exclude Zero (0) values from
calculating in an Average?

Must I use ... Sum/Count>0 ... or is there a better way?

Thanks ... Kha
 
B

Brian V

Use an array formula (SHIFT + CTRL + ENTER)
1. If A1:A8 is your range this formula will work:

=AVERAGE(IF(A1:A8,A1:A8))

*Remember to push SHIFT + CTRL + ENTER after typing your formula
BV
 
B

Bob Phillips

=AVERAGE(IF(C1:C10>0,C1:C10))

an array formula, so commit with Ctrl-Shift-Enter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excluding a paragraph tag from spelling check 0
Averaging two ranges on the same column (excluding zeros) 2
How to display zero value in blank fields of Cross Tab query 0
AVERAGE 7
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
autofilter average without zero 2
How do I exclude the HIGH and LOW values in the =AVERAGE function 2
Changing the range for averages with out changing the formula. 0

Top