If formula

B

Bea

I need to average agroup of cells but IF the total is "0" in one cell then I
do not want it to be average in.... How can I do this....
Exp. Average cells K13 - L13 = cell N23 But if ANY of the cells from K13 -
L13 = ")" I do not want them to be included in the average.
 
J

Jason Morin

Assuming all numeric values in cells:

=SUM(A1:A10)/COUNTIF(A1:A10,"<>0")

HTH
Jason
Atlanta, GA
 

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

Remove holidays from calculation 9
Trying to find additional ranges outside of min, max, and average 2
#DIV error 2
200KB versus 35MB 0
countifs Function not giving desired result with date criteria 2
I have a complex formula where I need to build in a MAX function 4
Can I add a range and then divide that sum by a specific value? 2
Remove the #DIV/0! 3

Top