Best way to sum months together?

[Monyridh_Yady]

Hi all this is my first time on this forum seeking help. I know this might seem super basic, but for the likes of me I can't seem to figure it out. I cannot upload pictures it seems so bear with me while I try to explain.

Take for example I have a Column with keys [Apples, Bananas, Coconuts.etc] and then I have multiple columns for dates so 1 column = 1 day, with the sales numbers. I could brute force this and eventually it gets me what I want, however, how would I go about summing the days together into months. So then each columns would be months instead of days with the sales summing as well.

Cheers.

[#2 · Accepted solution]

@Monyridh_Yady 

=SUMPRODUCT(($A$3:$A$6=$A10)*(MONTH($B$2:$J$2)=MONTH(B$9))*$B$3:$J$6)

You can try SUMPRODUCT.

[#3]

Thank you! This is just what I was looking for!