PDA

View Full Version : Solved: Counting Text with commas



AA_20069
04-03-2010, 10:57 AM
Hi guys,

thanks with ur help from last time, have another query i am guessing you

How can you count if a certain cell has a certain text in it e.g. cell B6 has CAR, WHEEL and B7 has WHEEL, GEAR as values.... and in row B1 it will show CAR = 1 and B2 shows that WHEEL = 3 and B4 shows that Gear = ONE....

obv that from B7 to end has different values with different text


Hope that makes sense...

Thanks

mdmackillop
04-03-2010, 12:01 PM
Hope that makes sense...
Not really :dunno
Can you post a workbook with sample data showing your data and expected result. Use Manage Attachments in the Go Advanced reply section.

Bob Phillips
04-03-2010, 02:10 PM
Try

=SUMPRODUCT(--(ISNUMBER(SEARCH("CAR",$B$6:$B$20))))

etc.

ZVI
04-03-2010, 03:46 PM
Hi, try attached example of the macro solution.
Vladimir

AA_20069
04-05-2010, 05:31 AM
Thanks guys... Worked like a charm xld :)

With some tweaking, i managed this

=SUMPRODUCT(--(ISNUMBER(SEARCH("CAR,",TRIM('CARDETAILS'!$L$4:$L$9996&",")))))

Bob Phillips
04-05-2010, 08:32 AM
You shouldn't need the TRIM with SEARCH>