Calculations

[Guest]

I have a spreadsheet containing employee hours. When I go to calculate each row of numbers, my answer is either "0" or it only calculates some of the hours. Why? I am using the =Sum) formula.

Please help.

Thanks.

 

[papou]

Hi Chele
It may be because the sum exceeds 24 hours in which case use the following
number format:
[h]:mm:ss

HTH
Regards
Pascal

I have a spreadsheet containing employee hours. When I go to calculate

each row of numbers, my answer is either "0" or it only calculates some of
the hours. Why? I am using the =Sum) formula.

 

[Ian]

It may also be that you have spaces either befor or after
your numbers. this would stop the columns from being
calculated.

-----Original Message-----
I have a spreadsheet containing employee hours. When I

go to calculate each row of numbers, my answer is
either "0" or it only calculates some of the hours. Why?
I am using the =Sum) formula.

 

[Guest]

I need to explain this differently...I don't have actual "times" I have a number of hours each employee works each week.

Sorry for the confusion.

Chele

Hi Chele
It may be because the sum exceeds 24 hours in which case use the following
number format:
[h]:mm:ss

HTH
Regards
Pascal

I have a spreadsheet containing employee hours. When I go to calculate

each row of numbers, my answer is either "0" or it only calculates some of
the hours. Why? I am using the =Sum) formula.

Please help.

Thanks.

 

[papou]

May be some of your data not entered as number?
In which case you should check formats.

Cordially
Pascal

I need to explain this differently...I don't have actual "times" I have a

number of hours each employee works each week.

Sorry for the confusion.

Chele

Hi Chele
It may be because the sum exceeds 24 hours in which case use the following
number format:
[h]:mm:ss

HTH
Regards
Pascal

I have a spreadsheet containing employee hours. When I go to

calculate
each row of numbers, my answer is either "0" or it only calculates some of
the hours. Why? I am using the =Sum) formula.

Please help.

Thanks.

 

[Guest]

All cells ARE formated as numbers. Just not sure why numbers won't add up. It is like there is something strange with my numbers. I have even done the "paintbrush" from one of the rows that is working. Getting really frustrated.

Chele

May be some of your data not entered as number?
In which case you should check formats.

Cordially
Pascal

I need to explain this differently...I don't have actual "times" I have a

number of hours each employee works each week.

Sorry for the confusion.

Chele

Hi Chele
It may be because the sum exceeds 24 hours in which case use the following
number format:
[h]:mm:ss

HTH
Regards
Pascal

"Chele" <[email protected]> a écrit dans le message de
I have a spreadsheet containing employee hours. When I go to calculate
each row of numbers, my answer is either "0" or it only calculates some of
the hours. Why? I am using the =Sum) formula.

Please help.

Thanks.

 

[Andy B]

Hi

Try typing =ISNUMBER(A1) in a column alongside your data. This should return
TRUE if they are numbers. If the cells were formatted as text before you
entered the numbers, painting them with a number format will not change
that. Neither will changing the format of the cells. One way is to copy a
blank unused cell, select your range and then Edit / Paste Special / Add
You should also check for spaces in the cell, as posted by Ian

--
Andy.

All cells ARE formated as numbers. Just not sure why numbers won't add

up. It is like there is something strange with my numbers. I have even
done the "paintbrush" from one of the rows that is working. Getting really
frustrated.

Chele

May be some of your data not entered as number?
In which case you should check formats.

Cordially
Pascal

I need to explain this differently...I don't have actual "times" I

have a
number of hours each employee works each week.

Sorry for the confusion.

Chele

:

Hi Chele
It may be because the sum exceeds 24 hours in which case use the following
number format:
[h]:mm:ss

HTH
Regards
Pascal

"Chele" <[email protected]> a écrit dans le message de
I have a spreadsheet containing employee hours. When I go to calculate
each row of numbers, my answer is either "0" or it only calculates

some
of

the hours. Why? I am using the =Sum) formula.

Please help.

Thanks.

 

[Ron Rosenfeld]

I have a spreadsheet containing employee hours. When I go to calculate each row of numbers, my answer is either "0" or it only calculates some of the hours. Why? I am using the =Sum) formula.

Please help.

Thanks.

Some of your numbers are really text.

If the number was entered as text, changing the format will not change that
feature. The SUM function ignores text.

If it is not easy to change the numbers to numbers, try this *array* formula:

=SUM(B1:Z1*1)

To enter an *array* formula, hold down <ctrl><shift> while hitting <enter>. XL
will place braces {...} around the formula.

You can also use the non-array formula:

=SUMPRODUCT(A1:A3*1)


--ron