Column formulas

[jdsl]

I am trying to take everything in column B and add it to the value in cell C18. Is there a way to add each cell in column B to C18 without it automatically adding C19, C20...? I only want B1 through B50 to be added to C18.

Thanks!

 

[yeheya]

=c18+sum(B1:B50)

Regards,
Yeheya