Forum Discussion
Solved
Automatically Adding Values from Separate Columns in Excel
I have an Excel spreadsheet with 2 columns, A & B. I would like column B to automatically populate a value once I insert a number into column A. Does anyone know how to do that? For (col...
Thank you, Hans, that makes total sense and it worked perfectly.
This is the first time I have ever tried "Blogging" and you answered the call quickly and correctly.
Very much appreciated.
- Ray (from Maryland)
Enter the following formula in B2:
=IF(A2="", "", SUM(B1,A2))
Fill down a good way, for example to B1000.
The cells in column B will remain blank until a value is entered in the corresponding cell in column A.
Thank you, Hans, that makes total sense and it worked perfectly.
This is the first time I have ever tried "Blogging" and you answered the call quickly and correctly.
Very much appreciated.
- Ray (from Maryland)