Results 1 to 3 of 3

Totaling multiple columns

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,174

    Totaling multiple columns

    I have a spreadsheet that contains about 3000 rows of data. For each row, I need to calculate a total quantity amount for each unique account number.

    The way I need the spreadsheet to calculate totals is: if all values in columns A, F, G, H in row 3 are all equal to same columns in row 2, then total the value in column E for rows 2 & 3. I can write a formula for this, but the problem I am running into is if there are more that 2 rows involved.

    Please see attached spreadsheet for what spreadsheet should look like. All the calculations are to take place in column J.

    Thanks
    Attached Files Attached Files

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