Good morning, I have a dynamic table that I can't get to add up with the format it has. What formula of the dynamic table must be put so that it can add. Thank you
Add.JPG
Good morning, I have a dynamic table that I can't get to add up with the format it has. What formula of the dynamic table must be put so that it can add. Thank you
Add.JPG
it would appear your data is 'text' not 'numeric'
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
They are seconds and appear in that format
see attached example - I cannot get a column simply formatted as :ss to totalise.
format the body as hh:mm:ss and if using a structured table with a totalising bottom row format that cell as [h]:mm:ss
select the 'Sum' function from the dropdown - the advantage of using a 'structured table' is the dynamic insert of new rows automatically copies down the formatting etc.,
It seems to work OK here.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
try putting an entry into an empty cell - neither a numeric nor :05 are accepted and do not compute for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks