Try...

=SUM(C3,C6,C9,C12,C15,C18,C21,C24,C27)

Hope this helps!

In article ,
Steved wrote:

Hello from Steved

I have formulas in cell C3,C6,C9,C12,C15,C18,C21,C24 and C27

If I do this =C3+C6+C9+C12+C15+C18+C21+C24+C27
I get a #VALUE! in the cell

Please What is require for me to get an answer.

Thankyou.