Column Sum Shortcode

  • Resolved SENO_Media

    (@seno_media)


    11 years, 3 months ago

    Hey there, just wondering if there is a way automatically add to columns together perhaps using a short code rather then typing in 1C+1D then 2C+2D all the way to say 100 players and so on.
    Basically I’m doing hockey stats and would just like Goals & Assists columns to automatically add for column “E”.

    Just wondering if its possible,

    Thanks!

    https://www.ads-software.com/plugins/tablepress/

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    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

    Thread Starter SENO_Media

    (@seno_media)

    Sorry wasn’t clear enough I need to total per row?

    Heres a link, https://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.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    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

    Thread Starter SENO_Media

    (@seno_media)

    its a hidden page. made it a password page, pass is: temp

    Plugin Author Tobias B?thge

    (@tobiasbg)

    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

    Thread Starter SENO_Media

    (@seno_media)

    I thought so. That’s okay, I can do it easily. Its my client that i’m scared of! ??

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    yeah, I understand. Sorry that I don’t have a solution here.

    Regards,
    Tobias

    Thread Starter SENO_Media

    (@seno_media)

    No worries and thank for your help. I may have another question for you which I’ll post in a new topic.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    sure, no problem ??

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Column Sum Shortcode’ is closed to new replies.