Your formula will fail if there is any non-numeric value in the cells being
added up.

"PaulinaDi" wrote:

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?