| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find max then sum cells above & to the left?
If
A1 = 1 B1 = 2 C1 = 3 A2 = 4 B2 = 5 C2 = 6 A3 = 9 B3 = 8 C3 = 7 How do I find the maximum value in row 3 and then sum the numbers in rows 1 and 2 above and to the right of the maximum value in row 3? I have tried the formula =SUM(OFFSET(MAX(A3:C3),-2,0,2,3)) but Excel doesn't appear to accept the maximum function within the offset function. Thanks in advance. Ian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the LEFT formula for multiple cells | Excel Worksheet Functions | |||
| Use of Find with Left, Mid, Right functions in nested IF(and('s | Excel Discussion (Misc queries) | |||
| TO FIND VALUE TO THE LEFT THE CELL USING VLOOKUP OR ANY OTHER | Excel Discussion (Misc queries) | |||
| Find LARGE, and th cell 3 cells to the left? | Excel Worksheet Functions | |||
| FIND or LEFT or MID to swap first name with last name? | Excel Worksheet Functions | |||
Threaded Mode
