Eggplant2016
New Member
- Joined
- Jan 20, 2019
- Messages
- 14
I have 4 cells that contribute to a total number.
Cells G24, N24, G32, N32. These cells currently sum a range of numbers from the 5 cells above them respectively.
The total number that these 4 cells add up to can be anywhere from an example number such as "1205.25" to something basic like "50"
Cells AJ6:AR6 are individual cells with AJ6 representing the hundred thousands all the way down to AR6 which represents the hundredths.
I need cell AR6 to take the sum of cells G24, N24, G32, N32 and only take the "hundredths" number. AQ6 will do the same but only take the tenths, AP6 will do the same and only take the ones, etc all the way to AJ6.
Is this possible??
Thank you so much for the help!
Cells G24, N24, G32, N32. These cells currently sum a range of numbers from the 5 cells above them respectively.
The total number that these 4 cells add up to can be anywhere from an example number such as "1205.25" to something basic like "50"
Cells AJ6:AR6 are individual cells with AJ6 representing the hundred thousands all the way down to AR6 which represents the hundredths.
I need cell AR6 to take the sum of cells G24, N24, G32, N32 and only take the "hundredths" number. AQ6 will do the same but only take the tenths, AP6 will do the same and only take the ones, etc all the way to AJ6.
Is this possible??
Thank you so much for the help!
Last edited: