Results 1 to 9 of 9

how do I add values prefixed with a letter

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-08-2008
    Location
    Belfast
    Posts
    112

    how do I add values prefixed with a letter

    Hi guys this is prob really easy easy to do but I'm stumped.

    I have a column which I simply enter overtime hours into and it is totalled up at the bottom, easy. I now have to on given days enter TOIL taken (time of in lieu) I'm thinking to distinguish from overtime hours entering it as T2 for 2 hrs TOIL etc. Is there a way that this entry can be added up recognising the T infront of the number. So far I've tried this =COUNTIF(C6:AG6,"t*") which allows me to enter T and a value but it only counts the number of times I enter a value of T3 etc and not the total. Hope that is as clear as mud. If I'm going down the wrong avenue then please point in the right direction.

    Thanks in advance
    Last edited by Davycc; 08-08-2008 at 01:52 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1