My "guess" is that if "Sum" worked, but =C3+C6+... did not work, then one of
your cells has text, and is not a number.
As technique, pull up the "Formula Auditing" toolbar, select your cell with
the value error, and click on the "Trace Error" button. It should point you
to the text cell that is causing the error.

HTH :)
--
Dana DeLouis
Win XP & Office 2003


"Steved" wrote in message
...
Thanks Domenic

"Domenic" wrote:

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.