On 2002-04-23 02:34, Ian Mac wrote:
On 2002-04-23 02:07, Phylis Sophical wrote:
I want to find the Average of cells F45 to Y45. But the last 5 cells (U45:Y45) do not have values in them yet. What do I need in the formula to ignore any cells that do not have a value, until they have a value. (number) in them?
You don't need anything other than AVERAGE() if it's JUST blanks or formula generated blanks.
I personally prefer to omit any error in this area by using something like
=SUM(F45:Y45)/COUNTIF(F45:Y45,">"&0).
then I have a clear understanding of the formula rather than just exepting something working because that's what its ment to do.