Forum Discussion
Using sumifs adding values between 2 dates
I am using a sumifs to return a sum based on a category between 2 dates. My formula is correct because it works on some computers but not others. =SUMIFS('2022 accounts'!$C$2:$C$2361,'2022 accounts'!...
Do the computers use different date formats? Try the following:
Enter the date 1-Dec-2022 in a cell, e.g. in X1, and the date 31-Dec-2022 in another cell, say Y1.
Change the formula to
=SUMIFS('2022 accounts'!$C$2:$C$2361,'2022 accounts'!$G$2:$G$2361,$B19,'2022 accounts'!$A$2:$A$2361,">="&X1,'2022 accounts'!$A$2:$A$2361,"<="&Y1)
HansVogelaar Many thanks. It is a simple and elegant solution. It does not account for why my original formula works on one computer but not another, even when all the dates are formatted the same. But I'm not an excel engineer, and I have my solution.
Thanks!