"dacm19" wrote:
... I need the D27 to change to D28 etc. as I copy horizontally...

But that is exactly how the suggested replacement will work in your formula
!??

Try this simple experiment to convince yourself

Put the numbers 1,2,3,4 into D27:D30

Now put in any cell other than D27:D30,
say in E3: =INDIRECT("D"&COLUMNS($A$1:A1)+26)

E3 will return what's in D27, i.e.: 1

Now copy E3 across to H3,
you'll see that E3:H3 returns what's in D27:D30
which is what you want

Give the earlier suggested formula (below) another try:
=IF(AND(AND(YEAR($A7)=YEAR($B$1),MONTH($A7)=MONTH( $B$1)),$B$7=INDIRECT("D"&C
OLUMNS($A$1:A1)+26)),$C7,0)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----