Hi,
thanks for your question.
The formulas in TablePress can be used in a similar pattern as in Excel, i.e. there’s an easy way to make a list of cells, like “C1+C2+C3+C4”: “SUM(C1:C4)”
Thus, to sum two columns (with e.g. 100 rows), you can use the short equation
=SUM(B2:C100)
Regards,
Tobias
Sorry wasn’t clear enough I need to total per row?
Heres a link, http://www.vernonotr.com/temp/
In the table that I have live I have =SUM(C2:D2) in the points column per row all the way down to =SUM(C72:D72)
In the link above I took the sum out so you can see what I would like to do.
Hi,
I’m not yet sure that I understand. And unfortunately, your link only gives me a 404 error 🙁 Is that really a published page?
Regards,
Tobias
its a hidden page. made it a password page, pass is: temp
Hi,
thanks! Now I can see the table.
Unfortunately, I don’t see an automatic way to do this in TablePress.
You will have to add (and adjust)
=SUM(C2:D2)
or
=C2+D2
and so on to each cell in the fifth column.
If you are familiar with Excel and macros, it might be possible to script this in Excel (i.e. write a script that adds those formulas to the cells) as an alternative.
Regards,
Tobias
I thought so. That’s okay, I can do it easily. Its my client that i’m scared of! 🙂
Hi,
yeah, I understand. Sorry that I don’t have a solution here.
Regards,
Tobias
No worries and thank for your help. I may have another question for you which I’ll post in a new topic.
Hi,
sure, no problem 🙂
Best wishes,
Tobias
P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!