Syntax Question

cyote101

Active Member
Joined
Dec 11, 2004
Messages
315
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.

(y)
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

tactps

Well-known Member
Joined
Jan 20, 2004
Messages
3,460
Can you post an example. This should never happen if your syntax is correct.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,210
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.
 

Forum statistics

Threads
1,181,124
Messages
5,928,246
Members
436,594
Latest member
asifm0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top