SUMIF autofill date criteria

So, I'm trying to use the autofill function in a SUMIF formula.


this is the base formula.
=SUMIF($B$5:$B$221,"01/03/2016",$C$5:$C$221)

I'm trying to get this.
=SUMIF($B$5:$B$221,"01/03/2016",$C$5:$C$221)
=SUMIF($B$5:$B$221,"02/03/2016",$C$5:$C$221)
=SUMIF($B$5:$B$221,"03/03/2016",$C$5:$C$221)

But, I'm getting this
=SUMIF($B$5:$B$221,"01/03/2016",$C$5:$C$221)
=SUMIF($B$5:$B$221,"01/03/2016",$C$5:$C$221)
=SUMIF($B$5:$B$221,"01/03/2016",$C$5:$C$221)

It's my first post here so if I'm doing something wrong please tell me.

Mar 1 2016

Maybe something like:

Formula:

Please Login or Register  to view this content.

BSB

I don't know how you did that. But it works!
Thank you BadlySpelledBuoy

Happy to help

All it's doing is adding a number to the date you already have.
ROWS($1:1) counts the number of rows in the range 1:1. In this case 1, then subtracts 1 from that to make zero.
Because there is a $ before the start row, that remains the same as you drag the formula down but no $ before the end row means that one increments.
So in the first formula it's adding zero to the date, in the second row it's adding 1 to the date, in the third it's adding 2 etc.

Hope that helps explain it.

BSB

It really does =)
Your explanation will help me in future works.
Thanks again!

Hi. Can you also help me with this?

I'm trying to get
=SUMIF(A:A,"6/12/19",C:C)
=SUMIF(A:A,"7/12/19",C:C)
=SUMIF(A:A,"8/12/19",C:C)

But, I am getting this
=SUMIF(A:A,"6/12/19",C:C)
=SUMIF(A:A,"6/12/19",C:C)
=SUMIF(A:A,"6/12/19",C:C)

I've been searching since yesterday, then I found this thread. Hope you could help me, thanks!