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.
|