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