G
Guest
I have numbers in cells J2:J8 right now. I will be adding a number to cell
J9 tomorrow and J10 the next day and so on. I need a formula to sum the last
10 numbers in the J column. Thanks. I thought this would work but it is not
for some reason
=SUM(INDIRECT("J"&MAX(1,COUNTA(J:J)-10)&".J"&COUNTA(J:J)))
Any ideas? Thanks
J9 tomorrow and J10 the next day and so on. I need a formula to sum the last
10 numbers in the J column. Thanks. I thought this would work but it is not
for some reason
=SUM(INDIRECT("J"&MAX(1,COUNTA(J:J)-10)&".J"&COUNTA(J:J)))
Any ideas? Thanks