Column formula does not advance

[kojak43]

In row 3710, column G, I have this formula: =IF(A3710=TODAY(),E3710,"")

Column H is the last column in the sheet that contains data. However, in column H, row 3710, this formula appears: =IF(A3709=TODAY(),SUM(G$2:G3709),"")

For some reason, the row number does not advance to G3710, it reads as the row above.

All the other columns, except for H, advance as I expect.

What am I doing wrong?

I am using Excel 2007 with Win7

 

[Michael M]

Is the formula copied by VBA.
If so, post your code.

 

[JoeMo]

In row 3710, column G, I have this formula: =IF(A3710=TODAY(),E3710,"")

Column H is the last column in the sheet that contains data. However, in column H, row 3710, this formula appears: =IF(A3709=TODAY(),SUM(G$2:G3709),"")

For some reason, the row number does not advance to G3710, it reads as the row above.

All the other columns, except for H, advance as I expect.

What am I doing wrong?

I am using Excel 2007 with Win7

Most likely an entry error was made. If you copy the formula in H3710 to H3711 and it becomes:

=IF(A3710=TODAY(),SUM(G$2:G3710),"")

then its advancing as expected. In that case, you need to correct the formula at its first use in column H and copy down.

 

[Michael M]

Hi Joe
good catch, I was thinking more of a last row error in VBA

 

[kojak43]

Most likely an entry error was made. If you copy the formula in H3710 to H3711 and it becomes:

=IF(A3710=TODAY(),SUM(G$2:G3710),"")

then its advancing as expected. In that case, you need to correct the formula at its first use in column H and copy down.

Thanks JoeMo, you were correct. The entry was in an early entry in Column H. I just fixed it and it seems to be working fine.

You are the best!