Forum Discussion
Solved
Excel counta/sumproduct formula help
I've created a table capturing trainings, their education units, and when the training was completed by fiscal year. I'm trying to calculate the each year's total sum training education units. ...
=SUMPRODUCT(($D$2:$G$12<>"")*($B$2:$B$12)*($D$1:$G$1=C15))You can try this SUMPRODUCT formula.
=SUMPRODUCT(($D$2:$G$12<>"")*($B$2:$B$12)*($D$1:$G$1=C15))You can try this SUMPRODUCT formula.
OliverScheurich ohhh that was super helpful! Thank you!
I adjusted the formula to this: =SUMPRODUCT((D$2:D$12<>"")*($B2:$B12)) Then dragged it across on the Total row to change accordingly for each column.