Average with month condition

Paywand

New Member
Joined
Apr 18, 2014
Messages
39
Dear all,

there is a column, contains a lot of percentage and beside it has a lot of date which equal to percentage column.

i want to average all percentage which beside date if equal "January"

thanks,
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Dear all,

there is a column, contains a lot of percentage and beside it has a lot of date which equal to percentage column.

i want to average all percentage which beside date if equal "January"

thanks,

If the date range is a true date range...

=AVERAGEIFS(A:A,B:B,">="&(1&E2)+0,B:B,"<="&EOMONTH(1&E2,0))

where E2 houses a month name like January.
 
Upvote 0
Maybe

=SUMPRODUCT((TEXT(A1:A5,"mmmm")="January")*(B1:B5))/SUMPRODUCT(--(TEXT(A1:A5,"mmmm")="January"))

 
Upvote 0
Then adjust the ranges as below

=SUMPRODUCT((TEXT(G1:G5,"mmmm")="January")*(H1:H5))/SUMPRODUCT(--(TEXT(G1:G5,"mmmm")="January"))
 
Upvote 0
Sorry the result was not correct, previously i have used this formula for counting H what equal to January in G

=SUMPRODUCT(--(H3:H1000<>"");--(MONTH(G3:G1000)=1))

but now i need that for the averaging which locate H3:H1000 and equal to January in G.
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

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