Assume that, you have below Student's Score Board Table, and you need to calculate the Maximum Scored number of an individual student in a single cell without creating any helper column.
Now In any cell (I've used D16), used the below any one formula:
=SUM(MAX(C2:C12+D2:D12+E2:E12+F2:F12+G2:G12+H2:H12+I2:I12))
=MAX(C2:C12+D2:D12+E2:E12+F2:F12+G2:G12+H2:H12+I2:I12)
=PRODUCT(MAX(C2:C12+D2:D12+E2:E12+F2:F12+G2:G12+H2:H12+I2:I12))
=INT(MAX(C2:C12+D2:D12+E2:E12+F2:F12+G2:G12+H2:H12+I2:I12))
All of these results formulas will get a result 71.
Image 1: Students Data Table
Now In any cell (I've used D16), used the below any one formula:
=SUMPRODUCT(MAX(C2:C12+D2:D12+E2:E12+F2:F12+G2:G12+H2:H12+I2:I12))
=SUM(MAX(C2:C12+D2:D12+E2:E12+F2:F12+G2:G12+H2:H12+I2:I12))
=MAX(C2:C12+D2:D12+E2:E12+F2:F12+G2:G12+H2:H12+I2:I12)
=PRODUCT(MAX(C2:C12+D2:D12+E2:E12+F2:F12+G2:G12+H2:H12+I2:I12))
=INT(MAX(C2:C12+D2:D12+E2:E12+F2:F12+G2:G12+H2:H12+I2:I12))
All of these results formulas will get a result 71.
Image 2: Students Data Table with answer
|||| Please SUBSCRIBE our YouTube Channel ||||
https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw
|||| Please SUBSCRIBE our YouTube Channel ||||
https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw