Forum Discussion
burnswattieoutlook
Dec 07, 2022Copper Contributor
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'!...
HansVogelaar
Dec 07, 2022MVP
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)
burnswattieoutlook
Dec 13, 2022Copper Contributor
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!