Posted to microsoft.public.excel.worksheet.functions

Harlan Grove[_2_] Harlan Grove[_2_] is offline

external usenet poster

Posts: 1,231

Count string IF.....

"Max" wrote...
One way:
=SUMPRODUCT((ISNUMBER(FIND({"WAP","RBT","MM4"},B2 :B5)))*(A2:A5="Joe"))
....

Another way, shorter but an array formula,

=COUNT(FIND({"WAP","RBT","MM4"},B2:B5)/(A2:A5="Joe"))

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 01:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us