Macro to add down a column
Closed
Blind156
venkat1926
- Posts
- 4
- Registration date
- Friday June 6, 2014
- Status
- Member
- Last seen
- June 20, 2014
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Macro to add down a column
- If a column has a value add to another column? ✓ - Forum - Excel
- Macro to add/remove rows based on highest # in group of cells ✓ - Forum - Excel
- Macro to blank out filtered columns ✓ - Forum - Excel
- Excel add unique id column ✓ - Forum - Excel
- Macro to add 1 to a cell value - Forum - Excel
1 reply
venkat1926
Jun 23, 2014 at 12:45 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Jun 23, 2014 at 12:45 AM
suppose your data is from A1 down to A8
in B1 type the formula
=SUM($A$1:A1)
copy B1 down
you know where it sums up to 8
quote
so a space would need to be inserted in the 5th column with the sum of 6 because it cannot add the 3 to surpass 8.
unquote
not clear what you want.
in B1 type the formula
=SUM($A$1:A1)
copy B1 down
you know where it sums up to 8
quote
so a space would need to be inserted in the 5th column with the sum of 6 because it cannot add the 3 to surpass 8.
unquote
not clear what you want.