Need help asap

[AIQ]

Hi all,
I have this formula in my spreadsheet:
=SUMPRODUCT(($E$2:$E$3000="URP")*(ISNUMBER(SEARCH("granuloma",$J$2:$J$3000))))

I need the formula to detect "URP" in column E when it is not a single entry. Some cells in column E might have (URP, URA, URM, ... ect). I tried typing an "*URP*" but apparently asterisk can not work with this formula. So I need the formula to count how many "URP" in column E regardless if it is single entry or with other values.
Can you guys please help?

 

[VoG]

Anything beginning with "UR"?

 

[AIQ]

No I need the exact word "URP"

 

[Marcelo Branco]

Do exactly as you did in column J

ISNUMBER(SEARCH("URP",$E2:$E$3000))

M.

 

[VoG]

No I need the exact word "URP"

What is the entire list that you want to match?

 

[AIQ]

=ISNUMBER(SEARCH("URP",$C1:$C$10))*(ISNUMBER(SEARCH("granuloma",$H$1:$H$10)))

If this is what you mean, it does not work. It gives me a 0 value

 

[Marcelo Branco]

=ISNUMBER(SEARCH("URP",$C1:$C$10))*(ISNUMBER(SEARCH("granuloma",$H$1:$H$10)))

If this is what you mean, it does not work. It gives me a 0 value

Try this

=SUMPRODUCT(ISNUMBER(SEARCH("URP",$C1:$C$10))*ISNUMBER(SEARCH("granuloma",$H$1:$H$10)))

M.

 

[AIQ]

OK this is an example of the spreadsheet
Column C Column E
URA URM Granuloma
URM Granuloma
URA Scar
URM Scar
URA Cyst
URP Abscess

Formula: =ISNUMBER(SEARCH("URP",$C1:$C$10))*(ISNUMBER(SEARCH("granuloma",$H$1:$H$10)))

Goal is to calculate how many patients share "URM" and "Granuloma"
answer should be = 2

BUT formula doesn't recognize multiple entries in the cell C1

Please help!

 

[AIQ]

Try this

=SUMPRODUCT(ISNUMBER(SEARCH("URP",$C1:$C$10))*ISNUMBER(SEARCH("granuloma",$H$1:$H$10)))

M.

This works ... THANKS ALOT!

 

[Marcelo Branco]

This works ... THANKS ALOT!

You are welcome and tks for the feedback

M.