Excel average - calculate average up-to-date, exclude non value fields

[pho01]

I have data for the whole fiscal year, for example:

Nov Dec Jan Feb Mar Apr...
12


Dec, Jan, Feb, Mar and Apr columns have none data, how do i use one formula to calculate the average up to date. For example, average would be 12 for the data above, not 12/12 (whole year) = 1

How can i achieve it in Excel?

Thanks!

 

[Gavona]

=Sum(range)/count(range)



Gavin

 

[byundt]

The AVERAGE function ignores blank cells and those containing text. So you could calculate your fiscal year to date average using:
=AVERAGE(range)

Brad