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!
Bookmarks