sum up to max value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have serie of data in one column where I want to sum up the values until I
have reached the maximum value of the data serie. Can anyone help me how it
is done?
 
I have serie of data in one column where I want to sum up the values until I
have reached the maximum value of the data serie. Can anyone help me how it
is done?
Click to expand...

=SUM(OFFSET(A1,0,0,MATCH(MAX(A:A),A:A,0)))

Change the cell references to reflect your column.


--ron
 
Pal,

You can create an array-formula for that:

{=SUM(IF(Interval<MAX(Interval),Interval))}

Remember to press CTRL+SHIFT+ENTER. The curly-brackets Excel will put for
you. The sum will occur in any order your data may appear or interval.

Regards,
Robert
 
Back
Top