Hello,

I am using the following formula to return sums between a date range in column A & B.
=SUMIFS($I$17:$I$100000,$A$17:$A$100000,">="&A3,$A$17:$A$100000,"<="&B3,$B$17:$B$100000,$C$2)

The error I get is that it is not returning the first date even though I am using ">=".

For example, date range in A:B is 08/1/21 & 08/31/21.

If the date is 08/2/21 to 08/31/21 it will sum, but will not sum any dates that are 08/01/21.

I appreciate any help figuring this one out.

Thank you,
Nick