I am trying to make an annual financial summary on a
userform which flashes up when the user double clicks.

I can do everything i need except sum a list of prices in
one column so i can display it in a label on the userform.

I know that this should be very simple but i just can't
get it to sum column a sheet2, i assumed it would be
something like....

Tots = Sum("a1:a33")
Label3.Caption = Tots

TIA