Results 1 to 6 of 6

Sum 1st col under col. 2 if the cel at col 2. equals a cell at col 3?

Threaded View

Meixroy Sum 1st col under col. 2 if... 03-26-2012, 06:14 AM
arlu1201 Re: Sum 1st col under col. 2... 03-26-2012, 06:23 AM
Meixroy Re: Sum 1st col under col. 2... 03-26-2012, 06:29 AM
arlu1201 Re: Sum 1st col under col. 2... 03-26-2012, 06:38 AM
Marcol Re: Sum 1st col under col. 2... 03-26-2012, 06:50 AM
Meixroy Re: Sum 1st col under col. 2... 03-26-2012, 06:54 AM
  1. #1
    Registered User
    Join Date
    03-26-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    5

    Sum 1st col under col. 2 if the cel at col 2. equals a cell at col 3?

    Hello Everyone, very happy to find about this forum.


    Five columns.

    Column one has the values that have to be summed.
    Column five has =MAX(column2, column4)

    So, at the bottom of column 2 it should show the summary of the values of column 1, as long as the matching cell in column 2 equals the cell in column 5 (assuming the summary checks row by row).

    Example:

    2 2 3 4 4
    3 9 3 2 9
    7 0 0 8 8

    So under the second column it would show 3 (because the second cell is the max value)
    Under the third column it would show 0 (because no cells in this column are the max value)
    Under the fourth column it would show 9 (because the first cell is the max value so that's 2, and than the third cell is the max value so it adds a 7)

    Attached an example file where SHOULD SHOW is the hopeful goal...

    Many thanks!
    Attached Files Attached Files
    Last edited by arlu1201; 03-26-2012 at 07:02 AM. Reason: Adding a file

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