averages - Ignoring some cells

[nparsons75]

I need to chart the average of some data over a number of months.

For example, I have 12 columns, Jan to Dec.

In each month is a percentage.

Jan - 46%
Feb - 25%
Mar - 60%
Apr - 55%
May - 47%
June - 38%

Now, I need to calculate the average of these percentages, which is easy aprt from this.

I need to take the average of all 12 months, but only include the months will good data, ie, jan to jun. July to december has a formula in there but not good data as yet.

So when data is good for July and entered this will become part of the average. As it is now my average takes into account all 12 months therefore incorrect.

All help appreciated.

 

[gaz_chops]

In older versions you could use

=AVERAGE(IF(B1:B12>0,B1:B12))

(Entered as an array)

 

[uk747]

I think (maybe wrong), countif & averageif became available from Excel 2007.

Countif can be used in Excel 2003

Maybe you are thinking of Countifs which became available in Excel2007

 

[gaz_chops]

Countif can be used in Excel 2003Maybe you are thinking of Countifs which became available in Excel2007

Ah told you I maybe wrong.

 

[uk747]

Ah told you I maybe wrong.

no probs.

=AVERAGE(IF(B1:B12>0,B1:B12))
Thanks, I learned a new array formula

 

[nparsons75]

Hi, how could I ignore errors also with this formula?

=AVERAGEIF(D61:O61,">"&0,D61:O61)