Forum Discussion
Solved
Best way to sum months together?
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 w...
=SUMPRODUCT(($A$3:$A$6=$A10)*(MONTH($B$2:$J$2)=MONTH(B$9))*$B$3:$J$6)You can try SUMPRODUCT.
=SUMPRODUCT(($A$3:$A$6=$A10)*(MONTH($B$2:$J$2)=MONTH(B$9))*$B$3:$J$6)You can try SUMPRODUCT.
- Thank you! This is just what I was looking for!
