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
--
raeleanne
------------------------------------------------------------------------
raeleanne's Profile:
http://www.excelforum.com/member.php...o&userid=25437
View this thread:
http://www.excelforum.com/showthread...hreadid=388759