Forum Discussion
Solved
SUM formula referencing dates
I need a SUMIF formula that will draw from the left table and provide a sum of the data between the dates FROM:TO and fill out the fields in bold in the right table. I've been trying to use SUMIF to ...
BMB199 Based on your example, assuming the top left corner is in A1 and the "Sum Data 1"-formula to be entered in I2, like this:
=SUMIFS(B$2:B$20,$A$2:$A$20,">="&$F2,$A$2:$A$20,"<="&$G2)Copy down and across.
BMB199 Based on your example, assuming the top left corner is in A1 and the "Sum Data 1"-formula to be entered in I2, like this:
=SUMIFS(B$2:B$20,$A$2:$A$20,">="&$F2,$A$2:$A$20,"<="&$G2)Copy down and across.