How to use macro to set "Sum" function
Do anyone know if i want to set a macro which i want to comprise 2 elements:
1: total underline
2: sum ("Sum" function in Excel which automatically sum up all the cells
with figures)
Every time i set, the no. of cells to be added are fixed. for example, Col A
has 3 cells to sum up; when i apply it to Col B which has 5 cells, it also
only add up the last 3 cells, not 5.
Can anyone advise me on this matter?
Thank you so much.
--
New user
|