I have to rewrite the following for Excel 2003

[rruu1963]

Hi, I have written the following in Excel 2007.

=IFERROR(AVERAGEIF($D:$D;"Event";E:E);" ")

This averages the numbers in column E if the word "Event" is present
in column D and leaves the cell blank otherwise. Works fine but....

I have been asked to rewrite it so Excel 2003 can understand it. I
have fumbled quite a lot with an Array Formula now, but I don't seem
to get it right.

Any good ideas?

Thank You from Robert in Oslo, Norway

 

[Niek Otten]

=IF(ISERROR(AVERAGEIF($D:$D;"Event";E:E));"
";(AVERAGEIF($D:$D;"Event";E:E)))

 

[Mike H]

Hi,

It's a bit more long winded in 2003

=IF(ISERROR(AVERAGE(IF(D11000="Event",E1:E1000))),"",AVERAGE(IF(D11000="Event",E1:E1000)))

Mike

 

[Mike H]

I forgot to mention I don't know if 2007 can handle full columns but 2003
can't hence my shortened ranges.

Mike

 

[Niek Otten]

Very clever, Mike!

 

[rruu1963]

Hi, I have written the following in Excel 2007.

=IFERROR(AVERAGEIF($D:$D;"Event";E:E);" ")

This averages the numbers in column E if the word "Event" is present
in column D and leaves the cell blank otherwise. Works fine but....

I have been asked to rewrite it so Excel 2003 can understand it. I
have fumbled quite a lot with an Array Formula now, but I don't seem
to get it right.

Any good ideas?

Thank You from Robert in Oslo, Norway

Thank You! It is so good to be able to ask people when you are stuck.

Robert