Simple Sum function question

[Brwnize1]

I know this is probably simple, but can someone tell me why a simple sum
function [e.g. =SUM(G1:G20)] would return a value of 0?

 

[Pete_UK]

Perhaps the values in G1:G20 look like numbers, but are actually text
values, so the SUM function cannot add them. You may need to format
the cells as General or Number, then click on an empty cell somewhere
and <copy>, then highlight G1:G20 and Edit | Paste Special | Values
(check) | Add (check) | OK and <Esc>. This will convert them to
numbers.

Hope this helps.

Pete

 

[Brwnize1]

Perhaps the values in G1:G20 look like numbers, but are actually text
values, so the SUM function cannot add them. You may need to format
the cells as General or Number, then click on an empty cell somewhere
and <copy>, then highlight G1:G20 and Edit | Paste Special | Values
(check) | Add (check) | OK and <Esc>. This will convert them to
numbers.

Hope this helps.

Pete

I know this is probably simple, but can someone tell me why a simple sum
function [e.g. =SUM(G1:G20)] would return a value of 0?

 

[Pete_UK]

I can't see any reply - did this work for you?

Pete

Perhaps the values in G1:G20 look like numbers, but are actually text
values, so the SUM function cannot add them. You may need to format
the cells as General or Number, then click on an empty cell somewhere
and <copy>, then highlight G1:G20 and Edit | Paste Special | Values
(check) | Add (check) | OK and <Esc>. This will convert them to
numbers.

Hope this helps.

Pete

I know this is probably simple, but can someone tell me why a simple sum
function [e.g. =SUM(G1:G20)] would return a value of 0?- Hide quoted text -

- Show quoted text -