Syntax Question

[cyote101]

Hello All,


I was just wondering why two diferent methods of adding multiple cells, why one worked better then the other

When I use "=a2+ad+........." it workes some of the times and not all of the time. But when I use "=SUM(.............)" it works almost all of the time.

Does anyone know the answer to this or is this one of those misteries of the univerce.

 

[tactps]

Can you post an example. This should never happen if your syntax is correct.

 

[Aladin Akyurek]

You probably mean getting #VALUE! errors with + but not with SUM. The reason for the error is that + does not ignore text values which cannot be coerced into true numbers. SUM is designed to ignore such values.