try the following, but you need to have the analysis toolpak add-ininstalled

replace E1 in the COLUMN() function with the address of a cell in the column
where this formula is to start


=IF(AND(EOMONTH($B$1,0)=EOMONTH($A7,0),$B$7=OFFSET ($D$27,COLUMN(E1)-5,0)),$C7,0)

"dacm19" wrote:

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.