Average IF's

  • Thread starter Thread starter Noodnutt @ Work
  • Start date Start date
N

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.
 
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
 
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
 
Back
Top