I am having a problem with Sumifs where it seems like it's not following the criteria correctly.
Here is my formula: =SUMIFS(B$2:B$895,A$2:A$895,"<="&$G2,A$2:A$895,"<="&$H2)
Column A: Dates
Column B: The data I want to sum
Column G and H: The criteria dates. I'm trying to do this in year increments so I have 1/1/1997, 1/1/1998...etc. in Column G and 12/31/1997, 12/31/1998 in Column H.
So what I want is for the formula to add up all the numbers in Column B that fall between 1/1/YYYY and 12/31/YYYY. That's not working tho...
Thanks in advance for help.
Bookmarks