+ Reply to Thread
Results 1 to 3 of 3

Summing total weight x reps?

  1. #1
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Summing total weight x reps?

    In the interest of making my spreadsheet as compact and simple as possible I am trying to figure out this forumla. Weight goes into column A, reps performed goes into column B. What formula would be able to calculate total weight lifted? Right now I am having to dedicate an entire column to calculating this and would like to condense it down to a single cell.

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Summing total weight x reps?

    If weight/rep is column A, and reps is column B, then I assume right now you have column C, where C1 = A1 * B1 right?
    And then you SUM(C1:C5) or whatever?

    If you want to compress all that into one cell of calculation, that would be,

    =SUMPRODUCT(A1:A5, B1:B1)

  3. #3
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Summing total weight x reps?

    That worked! Thank you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1