Forum Discussion
Solved
SUM by Month
Im trying to Sum by Month The data that is referenced is on a different worksheet in the same workbook. The table looks like this: Month 2017 2018 January $0.00 $0.00 February $0.00 ...
For such sample
formula in C3 is
=SUMPRODUCT((YEAR($F$3:$F$47)=C$2)*(TEXT($F$3:$F$47,"mmmm")=$B3)*$G$3:$G$47)
drag it the right and down.
You may adjust that to your ranges.
For such sample
formula in C3 is
=SUMPRODUCT((YEAR($F$3:$F$47)=C$2)*(TEXT($F$3:$F$47,"mmmm")=$B3)*$G$3:$G$47)
drag it the right and down.
You may adjust that to your ranges.