I'm thinking something like

=SUM(A1:A10)

would do or did you want this with VBA?

"Brian" wrote:

I have a multiple groups of data with line breaks between each. I would like
to sum the column and in the output cell, have the SUM equation. I want this
because I may change one of the value and would want it to update
automatically.

7
5
6
6
9
33 (<-output cell)

5
6
2
1
1
0
1
16 (<-output cell)