Average in Cells


I know how to calculate the Average within a range of cells - however,
what I would like to do is calculate the average but for only those
cells that return a figure based on the results of another formula -
example:if you have 6 cells but only 3 cells return a value, I would
like the average calculated on the 3 cells and not based on 6 - and
similarly, if another 2 figures are entered, the formula then
calculates the average of the 5 figures - hope this makes sense.


--
martins
------------------------------------------------------------------------
martins's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31616
View this thread: http://www.excelforum.com/showthread.php?threadid=526065

.

Loading