Macro to add down a column
Closed
Blind156
Posts
4
Registration date
Friday 6 June 2014
Status
Member
Last seen
20 June 2014
-
20 Jun 2014 à 09:59
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 23 Jun 2014 à 00:45
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 23 Jun 2014 à 00:45
Related:
- Macro to add down a column
- How to add a checkmark in word - Guide
- How to delete a column in word - Guide
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- How to add at the rate in laptop - Guide
- Excel column number - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
23 Jun 2014 à 00:45
23 Jun 2014 à 00:45
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.
