SOLVED

Best way to sum months together?

New Contributor

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 Replies
best response confirmed by Monyridh_Yady (New Contributor)
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.

sumproduct.JPG

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