AutoSum formula not adding commas

[Kimmerz29]

Hi

I'm trying to do an AutoSum on cells that do not intersect, and I keep getting a '#NULL!' error.

When I ctrl+click on each cell I want to add, the foumla is displaying (for example) =SUM(F5 D3 A1) instead of =SUM(F5, D3, A1)
If I try to manually enter the formula with the commas in place, it will not pick up the reference cells at all.

The only way it works is to manually put a '+' inbetween each referenced cell in the formula.

I have tried it on another computer and it works fine.

 

[lundbhaiz]

you could be trying to add cells which are formatted as text ?

 

[Kimmerz29]

I've tried formatting as numbers but it makes no difference

 

[Yahya]

in this formula
=SUM(F5 D3 A1)
the formula will sum just intersection between your range and if there is no intersection will return error NULL
to sum this, use this
=SUM(F5,D3,A1)

 

[lundbhaiz]

strange. mine is working fine. i have never came across this kind problem.

 

[lundbhaiz]

mr. yahya. this question is different.

 

[Kimmerz29]

It wont allow me to enter commas into the equation. If I manually enter the commas, I get a "The formula you typed contains an error".

There must be a wrong setting or something because we have this issue with 2 PC's at work, and the rest work perfectly fine.

I might try redeploying Office to these computers because I cant find a solution...

 

[lundbhaiz]

there is no guarantee that the fresh install of office on the computers would not have the same setting as it is having right now. pleaze wait. let me search for some more time if anything comes up i will post.

 

[lundbhaiz]

have you tried putting a dot instead of a comma ? which operating system you using at the right now ?

 

[Kimmerz29]

It will not accept a dot.

I am using Windows 7. All PC's were deployed with the same image.

Thanks