Had you tried this in vba you would have gotten an error msg. Then select
the word sum and use f1 to find out how.

Sub sumem()
MsgBox Sum("g5:g10")
End Sub

--
Don Guillett
SalesAid Software

"Susan Hayes" wrote in message
...
Hello

How can I sum up for example A4 through A16 and have the total appear in
A17, i.e., A17 = SUM(A4:A16)

What is the VBA syntax to get the above.


Thank you,

Jen T.