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.





2 Replies
best response confirmed by Monyridh_Yady (New Contributor)



You can try SUMPRODUCT.


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