IN B1 I have: 3,4,5 IN B2 I have the sum of these numbers 12
I would like to add these together and the sum to appear in B3
So, for B3, I need to tell excel to reference the cell holding the numbers, then add them together. This way, once I create the original formula, I can drag it through the remaining cells.
Reason is: The sum of these numbers (B2), are pulling the sum from a different location within the spreadsheet. I need to make sure these numbers match.
Thank you
See Question&Answers more detail:os