Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Summing a variable range of columns | Excel Worksheet Functions | |||
Match function...random search? | Excel Worksheet Functions | |||
Summing a range using INDIRECT & ADDRESS | Excel Worksheet Functions | |||
How to use linest with variably sized data arrays? | Excel Worksheet Functions | |||
summing part of cells in a range | Excel Discussion (Misc queries) |