Average IF's

[Noodnutt @ Work]

Hi Guy's

Can anyone help me out with the 2K version of the following plz.

=IF($C8=0,0,AVERAGEIF(Data!$AC$2:$AC$10000,"MAR-10",Data!L$2:L$10000))

This works great in 2007, but as with most things work related, they don't
have 2007 installed.

TIA
Mark.

 

[Fred Smith]

Average is Sum/Count, so use:
=IF($C8=0,0,SUMIF(Data!$AC$2:$AC$10000,"MAR-10",Data!L$2:L$10000)/COUNTIF(Data!$AC$2:$AC$10000,"MAR-10"))

Regards,
Fred

 

[Noodnutt @ Work]

All good peoples.

Worked it out.

It's always easier to see something clearer once you walk away and come back
after a coffee.

Cheers

 

[Noodnutt @ Work]

Cool

Thx Fred

Heaps better than my work-a-round.

Cheers
Mark.

 

[Fred Smith]

Glad to help. Thanks for the feedback.

Fred.

Cool

Thx Fred

Heaps better than my work-a-round.

Cheers
Mark.