Results 1 to 6 of 6
  1. #1
    Gill
    Guest

    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. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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>

    Legare Coleman

  3. #3
    Gill
    Guest

    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. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.
    Legare Coleman

  6. #6
    Gill
    Guest

    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.
    Thanks for your help.
    Gill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •