=MAX(B5,B36)+MAX(B6,B37)+MAX(B7,B38)+MAX(B8,B39)+MAX(B9,B40)+MAX(B10,B41)+MAX(B1

Question

=MAX(B5,B36)+MAX(B6,B37)+MAX(B7,B38)+MAX(B8,B39)+MAX(B9,B40)+MAX(B10,B41)+MAX(B11,B42)+MAX(B12,B43)+MAX(B13,B44)+MAX(B14,B45)+MAX(B15,B46)+MAX(B16,B47)+MAX(B17,B48)*MAX(B18,B49)+MAX(B19,B50)+MAX(B20,B51)+MAX(B21,B52)+MAX(B22,B53)+MAX(B23,B54)+MAX(B24,B55)+MAX(B25,B56)+MAX(B26,B57)+MAX(B27,B58)+MAX(B28,B59)+MAX(B29,B60)+MAX(B30,B61)+MAX(B31,B62)

Edit: Each cell in the 2 columns contains a formula. Meaning a cell appearing a empty is not a blank cell.

What I want to do is this:

I have 2 columns of numbers. B5:B31 and B36:B62. Each cell in each column can be any positive number from 1 upwards or a blank cell. I need to know the sum of the highest value from each of the pairs.

I tried {=SUM(MAX(B5:B31,B36:B62))} but all this did was return the highest value from the 2 columns.

Explanation / Answer

Try this Array Formula ( To be entered with CTRL+Shift+Enter)

=SUMPRODUCT((IFERROR((B5:B31)*1,0)>=IFERROR((B36:B62)*1,0))*(IFERROR((B5:B31)*1,0)))+SUMPRODUCT((IFERROR((B5:B31)*1,0)<IFERROR((B36:B62)*1,0))*(IFERROR((B36:B62)*1,0)))

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.