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.