Average IF / ONLY formula

MatthewGuy

New Member
Joined
Jul 15, 2019
Messages
2
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
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
It is but doesnt yield the correct average very often. You should almost always use the full data.
 
Upvote 0
Heres an example:

Length
Number
610
610
41

<tbody>
</tbody>

The average length using all the data is approx 5.9. Your method will produce 5.33.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,526
Messages
6,114,136
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top