Thread: How do I find max then sum cells above & to the left?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default How do I find max then sum cells above & to the left?
Perhaps more generic, placed in say, A5:
=SUM(OFFSET(IV1:IV2,,,,MATCH(MAX(3:3),3:3,0)-257))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Iany" wrote:
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
Reply With QuoteReply With Quote