One way:

=IF(COUNT(C9,E9,G9,I9,K9,M9,O9,Q9,S9,U9,W9),SUM(C9 ,E9,G9,I9,K9,M9,O9,Q9,S9,U9,W9),"")



--
Biff
Microsoft Excel MVP


"PaulinaDi" wrote in message
...
I guess I tried this formula before and not sure what happened but right
now
it worked fine.
And, to have a blank cell if I have no value on this row? how do I
complete
it with the If funcion?

"T. Valko" wrote:

Try using the SUM function. It will ignore any text entries.

=SUM(C9,E9,G9,I9,K9,M9,O9,Q9,S9,U9,W9)

--
Biff
Microsoft Excel MVP


"PaulinaDi" wrote in message
...
I have a table where I need to Sumarize different columns.

Eg:
=C9+E9+G9+I9+K9+M9+O9+Q9+S9+U9+W9 but in this row E9 and M9 have no
data
as
all these cells have their own formula from other files like
='[2008-dosbocas-porcompr.xls]DosBocas (mat)'!G6, ecc. So, in this case
these
E9 and M9 have no values.

The problem is that I am not able to use the first formula as I get a
#value
error.
What am I doing wrong?