Macro to add down a column
Closed
Blind156
Posts
4
Registration date
Friday June 6, 2014
Status
Member
Last seen
June 20, 2014
-
Jun 20, 2014 at 09:59 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 23, 2014 at 12:45 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 23, 2014 at 12:45 AM
Related:
- Macro to add down a column
- Pdf and xps add in 2007 - Download - Other
- How to add @ in laptop - Guide
- How to add songs to sound picker - Guide
- Add messenger to home screen - Guide
- How to add a tick in word - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jun 23, 2014 at 12:45 AM
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.