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.

Hi!

Create a list of all the unique INTS

Assume that list starts in cell D1

In cell E1 enter this formula and copy down

=SUMIF(B$1:B$100,D1,C$1:C$100)

Biff

"Titan" wrote in message
...
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.