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

Maybe

=SUMPRODUCT(--(A1:A10<>""))*(MID(A1:A10,2,999)+0)

VBA Noob

Sumif is like Countif... only it sums instead of counts...

e.g.

=SUMIF(C6:AG6,"t*")

Using your sample workbook, if you want to total the
numeric part of the T-values (eg T4+T6=10)...try this:

Please Login or Register  to view this content.

For that line in your workbook, the formula returns: 10

Am I on the right track here?

Sorry... I wasn't think straight... the Sumif won't work in this case because of the T in front and the fact that you can't really manipulate the Criteria part too much in this function...

I would try Sumproduct, like this:

=SUMPRODUCT((LEFT(C6:AG6)="t")*("0"&MID(C6:AG6,2,10)))

Edit: Looks like Ron beat me to it.. but we were thinking alike