Averages Formula

[cj21]

Guys

The problem I have is attached.

Thanks for the help.

Chris

[arthurbr]

Hi Chris
if I understand correctly you want to average the values of x/m corresponding to the first occurrence of the years?

[cj21]

Yes

That's right mate.

Thankyou

Chris

[BigBas]

Assuming your data spans Columns A:F, use a setup like this:

In Cell F2, enter:

=sumif(A2:A100,E2,C2:C100)/COUNTIF(A2:A100,E2)

and fill that formula down.

Let me know how that works for you.

[cj21]

Thanks for the help but it didn't work.

Anyone else got any ideas.

Thanks

Chris

[BigBas]

Can you post a sample of the file itself, in .zip format, so we can help you better?