Counting numbers even if there text in the column

[khank]

I have a document which has the hours for a week (6 dayS) - within those that week PC (personal time) and VT (vacation time) is marked.

Example:

F9: 11
G9: 7.75
H9: 6.75
I9: 7.75
J9:
K9: PC

The total should be 33.25, I'm using a =SUM(F9+G9+H9+I9+J9+K9) and I'm getting #VALUE!.

I know this should be a simple coding - I guess I'm just brain dead today. Any suggestions for my hang-up?

[Colin Legg]

Hi,

The + operator is the problem. It doesn't like it when you tell it to try to add a string such as "PC".

SUM() adds all of the numbers anyway so you don't need the + operator here:

=SUM(F9,G9,H9,I9,J9,K9)

which can be shortened to:

=SUM(F9:K9)

[khank]

Colin thanks - some days' you can't see the forest because of the trees...