Carlgordonrocks
Board Regular
- Joined
- Mar 26, 2007
- Messages
- 55
Morning all
I have a formula that sums various figures on a spreadsheet. Below this I want to show which figures are added to come to this total. I could just type this out manually but the numbers involved will change.
e.g. the numbers 100 (in cell A1), 200 (in cell B3), and 300 (in cell C5) are totaled in cell E6 to 600. In Cell E7 I would like to show 100+200+300. If B3 changes to 500 then E6 should show 900, and E7 would then show 100+500+300.
Is there a way to do this or do I just need to adjust this manually?
I have a formula that sums various figures on a spreadsheet. Below this I want to show which figures are added to come to this total. I could just type this out manually but the numbers involved will change.
e.g. the numbers 100 (in cell A1), 200 (in cell B3), and 300 (in cell C5) are totaled in cell E6 to 600. In Cell E7 I would like to show 100+200+300. If B3 changes to 500 then E6 should show 900, and E7 would then show 100+500+300.
Is there a way to do this or do I just need to adjust this manually?