LinkBack URL
About LinkBacks
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
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
Try this.....
In B4
and copy across to say R4.
Please Login or Register to view this content.
And in E5
Is this what you are trying to achieve?Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
thanks for your reply but
I want booth the function in single formula
Interesting.
=MAX(SUM(A3:C3),SUM(D3:F3),SUM(G3:I3),SUM(J3:L3),SUM(M3:O3),SUM(P3:R3)) is the simplest
Last edited by martindwilson; 06-07-2014 at 10:23 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
The data range may vary
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks