Forum Discussion

melissat-sfdph's avatar
melissat-sfdph
Copper Contributor
Aug 22, 2023
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. The thought process is if there is a date in the cell, you multiple it by the ELU column; then add it all up to give you the sum of how many education units were completed per year.

 

I see in that this is possible with the sumproduct but it works with numbers, $, etc. Unclear how to make it work for dates. Otherwise, I can manually calculate it but if it's possible to have a formula that would be easy to apply across the board to other training topics. Any guidance or assistance would be helpful. Thanks!

2 Replies

    • melissat-sfdph's avatar
      melissat-sfdph
      Copper Contributor

      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.

Resources