# Thread: Average IF / ONLY formula Thanks: 0 Likes: 0

1. ## Average IF / ONLY formula

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

2. ## Re: Average IF / ONLY formula

Are you trying to do averages of averages?

3. ## Re: Average IF / ONLY formula

Originally Posted by steve the fish
Are you trying to do averages of averages?
Hi Steve,

I am yes. Is this possible?

Kind regards,
Matthew

4. ## Re: Average IF / ONLY formula

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

5. ## Re: Average IF / ONLY formula

Heres an example:

 Length Number 6 10 6 10 4 1

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

6. ## Re: Average IF / ONLY formula

formula syntax is wrong

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