Enter the following formula as an array formula, that is, confirm with
CTRL+SHIFT+ENTER unstead of just with ENTER

=SUM(IF(RIGHT(A1:A10,1)="T",VALUE(LEFT(A1:A10,LEN( A1:A10)-1)),0))

If you did this correctly, the formula will show in curly brackets, to show
that it is an array formyla

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"LiAD" wrote in message
...
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