a summation problem

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Can anyone out there help me with the following.
I have a list of numbers, say:
0
30
15
40
20
....and in the adjacent column i want Excel to sum the
numbers in the above column that are less-than-or-equal-to
the corresponding cell to the left of it horizontally. The
output should then be like this:
0 0
30 65
15 15
40 105
20 35

That's all, i'm sure it's not too hard, but i just cannot
make it happen.

martin
 
Slightly different...if you give your column of numbers a range name (say,
"data"), Excel is able to distinguish between the entire range "data", and
the cell on the same row within "data".

=SUMIF(data,"<=" & data)
 
Back
Top