| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Max of Summed Values
Is there a more streamlined way to calculate this?
=MAX(SUM(I2,J2),SUM(I3,J3),SUM(I4,J4),SUM(I5,J5),S UM(I6,J6),SUM(I7,J7),SUM(I8,J18),SUM(I9,J9),SUM(I1 0,J10),SUM(I11,J11),SUM(I12,J12),SUM(I13,J13),SUM( I14,J14),SUM(I15,J15),SUM(I16,J16),SUM(I17,J17),SU M(I18,J18),SUM(I19,J19),SUM(I20,J20),SUM(I21,J21), SUM(I22,J22),SUM(I23,J23),SUM(I24,J24),SUM(I25,J25 ),SUM(I26,J26),SUM(I27,J27)) This =MAX(SUM(I2,J2),SUM(I27,27)) only finds the max of I2+J2 and I27+J27 This =MAX(SUM(I2:J2):SUM(I27:J27)) returns a formula error. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find values in multiple cells and paste row values | Excel Discussion (Misc queries) | |||
| find largest values, then return corresponding row values. | Excel Discussion (Misc queries) | |||
| Add to Summed Figures | Excel Worksheet Functions | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
| SUMIF where values to be summed are formula | Excel Worksheet Functions | |||
Threaded Mode
