kojak43
Active Member
- Joined
- Feb 23, 2002
- Messages
- 270
At the end of the last column in the dataset, I press Tab to go to the next record. The last column in the Pivot Table dataset uses column "G". In "H" I have a running total that reads, =IF(A784=TODAY(),SUM(G736:G2069),"").
For some reason, when I press Tab, the function changes and "jump's" records. So, if I am at "G" and "H" reads =IF(A784=TODAY(),SUM(G736:G2069),""), when I press Tab, I am then in record 785, but the function reads =IF(A786=TODAY(),SUM(G736:G2069),"").
What am I doing wrong?
Thanks for your guidance
k
For some reason, when I press Tab, the function changes and "jump's" records. So, if I am at "G" and "H" reads =IF(A784=TODAY(),SUM(G736:G2069),""), when I press Tab, I am then in record 785, but the function reads =IF(A786=TODAY(),SUM(G736:G2069),"").
What am I doing wrong?
Thanks for your guidance
k