# Thread: TPutting text in a value box

1. ## TPutting text in a value box

I have created a spreadsheet, which contains weekly tables giving, for each of our technicians, the daily hours worked, the hours sold and non-productive time. The totals for each technician per week are then put into a further table to give a monthly table. My problem is, if a technician is away for a day, as soon as I type

2. ## Re: TPutting text in a value box

How are you calculating the value in the total cell. If you use the SUM function, it should skip the cells with text. If the hours workked are in cells A1 to E1, then the SUM formula would be:

<pre>=SUM(A1:E1)
</pre>

3. ## Re: TPutting text in a value box

I can't use the @sum formula because the cells that are added together are not next to each other i.e. I have to add for example M5 + M11 + M16 + m24

4. ## Re: TPutting text in a value box

Sum(M5,M11,M16,M24) will do what you want.

Thanks Legare, I did not know that SUM(..) ignores cells with text.

5. ## Re: TPutting text in a value box

You can still use SUM, just put commas between the cells like this:

<pre>Sum(M5,M11,M16,M24)
</pre>

There is a limit (15 if I remember correctly) on the number of arguments that can be passed to Sum(). If you have more cells than that, you will have to add together more than one Sum() function.

6. ## Re: TPutting text in a value box

Thanks very much, Legare. Your first reply had actually already sent me on the right track and it now works very well. Your way is simpler than mine though so will use that in future.