I want to find a formula to sum each 3 Cells as Group and find the Maximum Value from them

[samba_ravi]

I am looking for a formula which Sums 3 Cells as Group and next find the maximum value from that for ex:
have a data from A1:R1
then it sums A1:C1, D1:F1, G1:I1, J1:L1, M1 to O1 and P1 to R1
Next display the Maximum value of the above

[sktneer]

Try this.....

In B4

Please Login or Register  to view this content.

and copy across to say R4.

And in E5

Please Login or Register  to view this content.

Is this what you are trying to achieve?

[samba_ravi]

thanks for your reply but
I want booth the function in single formula

[sktneer]

Interesting.

[martindwilson]

=MAX(SUM(A3:C3),SUM(D3:F3),SUM(G3:I3),SUM(J3:L3),SUM(M3:O3),SUM(P3:R3)) is the simplest

[samba_ravi]

The data range may vary