adamexcel233
New Member
- Joined
- Oct 6, 2018
- Messages
- 2
I'm trying to carry over numbers after the decimal point (column in green) and add them to the row belowAt the moment, the RED items are being calculated in each row, and the total is show in BLUE. The number in BLUE is then divided by 7.5 and show in GREEN.
A. 47.50 47.50 47.00 47.00 189.00 25.20
B. 48.50 47.50 44.50 47.50 188.00 25.07
C. 49.00 57.50 53.00 53.50 213.00 28.40
In the GREEN column I have this formula:
=SUM(BLUECOLUMNNUMBER/7.5)
I need to carry over the number in the previous row to the next column, for example:
GREEN Column in B should be 25.27
GREEN Column in Cshould be 25.67
It's probably simple, but can anyone help?
Thanks
A. 47.50 47.50 47.00 47.00 189.00 25.20
B. 48.50 47.50 44.50 47.50 188.00 25.07
C. 49.00 57.50 53.00 53.50 213.00 28.40
In the GREEN column I have this formula:
=SUM(BLUECOLUMNNUMBER/7.5)
I need to carry over the number in the previous row to the next column, for example:
GREEN Column in B should be 25.27
GREEN Column in Cshould be 25.67
It's probably simple, but can anyone help?
Thanks