I would like $D27 in this function to increment the row by 1 as I copy to
other columns to the right of it. How do I do that?

=IF(AND(AND(YEAR($A7)=YEAR($B$1),MONTH($A7)=MONTH( $B$1)),$B$7=$D$27),$C7,0)

I would appreciate any help I can get on this one.

Thanks.