Sumif contains formula
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
|