Posted to microsoft.public.excel.worksheet.functions

Coley

external usenet poster

Posts: 7

Count string IF.....

I am trying to count a 3 digit embeded data string IF....

NAME DATA_STRING
Joe WAPDATMM4RT1RRR
Susan WAPDATPLBMM5UDF
John DATPLBINSRBTMM6
Joe WAPUDARBTRRRMM4

I can count the strings with...
=SUM(COUNTIF(B2:B5,"*WAP*"),COUNTIF(B2:B5,"*RBT*") ,COUNTIF(B2:B5,"*MM4*"))
result (7)
I need the result IF A2:A5=Joe result (5)
I have stared at SUMPRODUCT long enough....H E L P !

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count characters within a string	Francisco	Excel Worksheet Functions	4	April 10th 07 05:28 PM
Count rows with a string in any cell	andy62	Excel Worksheet Functions	5	August 8th 06 05:31 AM
count number of letters in a string	Wiley	Excel Worksheet Functions	3	May 11th 06 06:54 PM
Colomn of strings, how to count each string with "abc" OR "def"	Tommy T	Excel Worksheet Functions	8	September 5th 05 04:57 PM
count number of occurences within a string	Gabriel	Excel Worksheet Functions	2	November 25th 04 04:17 PM

All times are GMT +1. The time now is 02:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us