Forum Discussion
Solved
Adding up numbers that fall in a range of dates (not as simple as it sounds)
Hi All I assume that this isn't that complicated and I am just lacking the correct terms to find the answers. I just get solutions to kind of the opposite problem when I try. Here is my probl...
Let's say that you enter the dates 1-Jan-21, 2-Jan-21 etc. in F2 and down.
Enter the following formula in G2:
=SUMIFS($C$2:$C$100,$A$2:$A$100,"<="&F2,$B$2:$B$100,">="&F2)
Adjust the ranges, then fill down.
Let's say that you enter the dates 1-Jan-21, 2-Jan-21 etc. in F2 and down.
Enter the following formula in G2:
=SUMIFS($C$2:$C$100,$A$2:$A$100,"<="&F2,$B$2:$B$100,">="&F2)
Adjust the ranges, then fill down.
That works beautifully, Thanks so much.
Andy
