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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

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,209
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,147,508
Messages
5,741,570
Members
423,668
Latest member
Audorin

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