Hi,

I have list of data that contains items made of numbers and numbers+T.
Example

5
500T
0.3
0.21T
158987T
1
8
7
663
12.45T

What formula can I use to Sumif the number contains T and no calculate the
other values at all? So the answer i need for the above list is 159499.66.

Thanks
LiAD