Thread: Average IF's
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Noodnutt @ Work Noodnutt @ Work is offline
external usenet poster
 
Posts: 7
Default Average IF's

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" wrote in message
...
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.