Average IF / ONLY formula

[MatthewGuy]

Afternoon all,

Scoured the forum and can't find anything that meets my needs.

I'm looking to create a "library" of sorts that calculates an average score, based on a number of marking definitions.

We often look back through previous months and update scores so I was trying to find out if there was a foruma that would calculate an average only if the date put in collumn B correlated with a specific month.

Looking around online I've tried a reccomended formula "{=AVERAGE(IF(MONTH(B:B=5),H:H))}" but it doesn't seem to have worked.

http://tinypic.com/r/24eudxl/9

http://tinypic.com/r/21dndc9/9

Thanks in advance

 

[steve the fish]

Are you trying to do averages of averages?

 

[MatthewGuy]

Are you trying to do averages of averages?

Hi Steve,

I am yes. Is this possible?

Kind regards,
Matthew

 

[steve the fish]

It is but doesnt yield the correct average very often. You should almost always use the full data.

 

[steve the fish]

Heres an example:

<tbody>
[TD="class: xl63"] Length
[/TD]
[TD="class: xl63, width: 64"]Number[/TD]

[TD="class: xl63"]6[/TD]
[TD="class: xl63"]10[/TD]

[TD="class: xl63"]6[/TD]
[TD="class: xl63"]10[/TD]

[TD="class: xl63"]4[/TD]
[TD="class: xl63"]1[/TD]

</tbody>

The average length using all the data is approx 5.9. Your method will produce 5.33.

 

[theBardd]

formula syntax is wrong

=AVERAGE(IF(MONTH(B:B)=5,H:H))