Column tally stopped working when extending the table manually.
Hi!
Here column H automaticallly tallies amounts entered in column F. (file attached).
When extending the table manually, the formula in the last cell of H changes its own range to read the bottom of the table, at that point tallying in column H goes weird when I enter figures into column F.
It should work even when I extend the table down. (All my other columns seem to continue correctly except H).
Screenshot_20210426143730.png
Screenshot_20210426143814.png
Explain what it's supposed to be doing and in what way it isn't working for you. We have no way of knowing what your expectations are from 'weird'.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
No expert on tables but:
in H2
=IF(F2="","",SUM(F$2:F9))
in H111
=IF(F111="","",SUM(F$2:F118))
Appears consistent
in F112
=IF(F112="","",SUM(F$2:F119))
as cells F119 onwards are blank total remains the same for subsequent totalling
in I113
=IF(G113="","",SUM(G$2:G113))
in I114
=IF(G114="","",SUM(G$2:G121))
in I115
=IF(G115="","",SUM(G$2:G122))
????
Ali I have a formula in column H to tally the invoice amount in column F, it was working up to row 114, until I extended the table down to row 121, when I added $1000 in row 115, column H simply repeated the figure above it instead of continuing to tally.
i`ve also attached a new spreadsheet to show exactly what I just explained.
I don`t know if I am writing the formula correctly. The formula should just continue when I extend the table, not sure why it stops working.
Attachment 729888
Last edited by jitterbug888; 04-26-2021 at 06:13 AM.
Change
H2 to
=IF(F2="","",SUM(F$2:[@[invoice amount]]))
I2 to
=IF(G2="","",SUM(G$2:[@GST]))
AH you are brilliant Bo thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks