If your data is in column A, rows 1-205, then in cell A206, type:
"=SUM(A1:A205)" (without the quotes)

"SLP" wrote:

Hello. I am trying to do an =sum for 205 rows. The result is 0. I checked
Tools | Otpions -- Automatic is set. The cells leading into the =sum are
formatted as numbers. (Also tried it with General). The cells that lead into
those cells are not text. Any ideas on what is wrong? Thanks.