Using Sumif to dynamically sum the values in column C for a 6 month prior period for the current year, 2021.
Formula is correct - the sum for the desired months is displayed.
Sum is correctly displayed as "21."
Conceptually, if I modify the Year(TODAY()) portion by appending "-1", as displayed below, I should sum the same six month period in the prior year.
This is not occurring. Any insight as to why?
Sum of the numbers is incorrectly displayed as 59.
How should the formula be modified to allow for the dynamic Year over Year analysis for the same six month period?
Have ensured that the values in column A is indeed formatted as dates. Also, re-calculated by pressing F9.
Thanks in advance for any insight!
Formula is correct - the sum for the desired months is displayed.
Code:
'=SUMIFS($C$7:$C$30,$A$7:$A$30,">="&DATE(YEAR(TODAY()),MONTH(TODAY())-6,1),$A$7:$A$30,"<="&DATE(YEAR(TODAY()),MONTH(TODAY())-1,1))
Sum is correctly displayed as "21."
Conceptually, if I modify the Year(TODAY()) portion by appending "-1", as displayed below, I should sum the same six month period in the prior year.
This is not occurring. Any insight as to why?
Code:
'=SUMIFS($C$7:$C$30,$A$7:$A$30,">="&DATE(YEAR(TODAY())-1,MONTH(TODAY())-6,1),$A$7:$A$30,"<="&DATE(YEAR(TODAY()),MONTH(TODAY())-1,1))
Sum of the numbers is incorrectly displayed as 59.
How should the formula be modified to allow for the dynamic Year over Year analysis for the same six month period?
Have ensured that the values in column A is indeed formatted as dates. Also, re-calculated by pressing F9.
Thanks in advance for any insight!