Begineer with (seemingly) hard problem

Here is an updates document with kids that have more than one disorder.
At the moment there is just a few spaces between each disorder and therefore it will not count them in the results.

Not sure what I am best to do..

Thanks,

* the files is renamed to doc once again....

- Mark Rayner

Hi!

OK.....

In column H just continue to enter the data like you are. If you need to
enter more than 1 condition per cell keep separating them using a space.
Don't use commas or semi-colons or any type of punctuation symbol.

Formula in U3:

=SUMPRODUCT(--(C$4:C$500="M"),--(ISNUMBER(SEARCH(" "&N3&" "," "&H$4:H$500&"
"))))

Formula in W3:

=SUMPRODUCT(--(C$4:C$500="F"),--(ISNUMBER(SEARCH(" "&N3&" "," "&H$4:H$500&"
"))))

Biff

"mrayner" <mrayner.1rboma_1119938707.2677@excelforum-nospam.com> wrote in
message news:mrayner.1rboma_1119938707.2677@excelforum-nospam.com...
>
> Here is an updates document with kids that have more than one disorder.
> At the moment there is just a few spaces between each disorder and
> therefore it will not count them in the results.
>
> Not sure what I am best to do..
>
> Thanks,
>
> * the files is renamed to doc once again....
>
> - Mark Rayner
>
>
> +-------------------------------------------------------------------+
> |Filename: Support Team Data Small.doc |
> |Download: http://www.excelforum.com/attachment.php?postid=3544 |
> +-------------------------------------------------------------------+
>
> --
> mrayner
> ------------------------------------------------------------------------
> mrayner's Profile:
> http://www.excelforum.com/member.php...o&userid=24656
> View this thread: http://www.excelforum.com/showthread...hreadid=382382
>