Simple Sum function question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Pete_UK said:
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?
Click to expand...
Click to expand...
 
I can't see any reply - did this work for you?

Pete

Pete_UK said:
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.
Click to expand...
Hope this helps.
Pete
Click to expand...

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 -
Click to expand...
Click to expand...

- Show quoted text -
Click to expand...
 
Back
Top