View Single Post
  #1   Report Post  
Titan
 
Posts: n/a
Default Summing a variably-sized range

I have a list of ages in one column, adjacent to it, is the 'fractional' part
of the age:

AGE INT AGE-INT
54.32 54 0.32
55.21 55 0.21
55.43 55 0.43
55.54 55 0.54
56.88 56 0.88
56.94 56 0.94

I want to create a column that would sum 'AGE-INT' where all the 'INT's are
the same. For example the above might produce: '0.32 1.18 0 0 1.82 0'.
The zeroes could be in different places or not even present, that would be
fine. Is there a way to do this without writing a macro, because I've never
done that before.