ExcelBanter - Average IF's

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Average IF's (https://www.excelbanter.com/excel-worksheet-functions/264713-average-ifs.html)

Noodnutt @ Work

Average IF's

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[_4_]

Average IF's

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

Noodnutt @ Work

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.

Noodnutt @ Work

Average IF's

Cool

Thx Fred

Heaps better than my work-a-round.

Cheers
Mark.

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

Fred Smith[_4_]

Average IF's

Glad to help. Thanks for the feedback.

Fred.

"Noodnutt @ Work" wrote in message
...
Cool

Thx Fred

Heaps better than my work-a-round.

Cheers
Mark.

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

All times are GMT +1. The time now is 12:48 PM.