conditional counting with Excel

[LeicaElmar]

I;m new here and need help with something.

We are counting chemical compounds and need a way to count tw
columns. One column tells the group it originated.Another says yes o
no if it has been ordered.

I am using COUNTIF to count particular groups in both of thos
columns. For example, COUNTIF counts the number of yes to tell u
which unique compound has been analyzed. Theother may have the compoun
group and we use COUNTIF for the groups if it stands alone or not by
for example) "*amino*".

What we want is everywhere a NO is changed to YEs in a row wher
*Amino* is located, we want it to increase the count of amino in ou
list. I;m lost on this and hope someone can help. Doing this helps t
make keeping a count easy rather than going in periodically an
physically counting the "Amino" and each row that has a yes.

thanks for your hel

 

[Aladin Akyurek]

Are you looking for...

=SUMPRODUCT(--ISNUMBER(SEARCH(X2,CompoundRange)))

where X2 houses the string condition of amino?