Recognizing Text

[kunjanee]

How to I make this formula work.

=SUMIFS('CLIN Data'!$F$208:$F$301,'CLIN Data'!$A$208:$A$301,TEXT(MID($A2,16,4),"0.0"))

For this portion, 'CLIN Data'!$A$208:$A$301,TEXT(MID($A2,16,4),"0.0", it is looking for 2.1. And then I need it look for this.

=SUMIFS('CLIN Data'!$F$208:$F$301,'CLIN Data'!$A$208:$A$301,TEXT(MID($A11,16,4),"0.00")), where this is looking for 2.10, but it is totaling all the data for 2.1 and 2.10 together.

Someone please help!

Thanks!

[sandy666]

some text examples for TEXT(MID($A2,16,4),"0.00") pls

try :

=MID($A2,SEARCH(".",$A2,1)-1,4)
but it will be text not number like in your formula also.
or simply:
=MID($A2,16,4)

I assume, after 2.1 or 2.10 is nothing more