Try...

=AVERAGE(IF(N(INDIRECT({"C32","C58","C84","H32","H 58","H84}))0,N(INDIRECT({"C32","C58","C84","H32", "H58","H84}))))

or

=AVERAGE(IF(SMALL((C32,C58,C84,H32,H58,H84),{1,2,3 ,4,5,6})0,SMALL((C32,C58,C84,H32,H58,H84),{1,2,3, 4,5,6})))

Both these formulas need to be confired with CONTROL+SHIFT+ENTER, not
just ENTER.

Hope this helps!

raeleanne Wrote:
One more problem and this spreadsheet should be done...

I need to average the results in a number of cells
(C32+H32+C58+H58+C84+H84) without including cells that have a value of
0.0%

I have tried:
=AVERAGE(IF((C32+H32+C58+H58+C84+H84)=0,(C32+H32+ C58+H58+C84+H84)))
but this just seems to Add everything together

I can't sum the cells and then divide by a COUNTIF becuase it won't let
me select anything other than a range.

Any suggestions? Is it even possible?

Thanks


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=388759