Home |
Search |
Today's Posts |
#1
|
|||
|
|||
conditional counting with Excel
I;m new here and need help with something. We are counting chemical compounds and need a way to count two columns. One column tells the group it originated.Another says yes or no if it has been ordered. I am using COUNTIF to count particular groups in both of those columns. For example, COUNTIF counts the number of yes to tell us which unique compound has been analyzed. Theother may have the compound 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 where *Amino* is located, we want it to increase the count of amino in our list. I;m lost on this and hope someone can help. Doing this helps to make keeping a count easy rather than going in periodically and physically counting the "Amino" and each row that has a yes. thanks for your help -- LeicaElmar ------------------------------------------------------------------------ LeicaElmar's Profile: http://www.excelforum.com/member.php...o&userid=28082 View this thread: http://www.excelforum.com/showthread...hreadid=476954 |
#2
|
|||
|
|||
conditional counting with Excel
Are you looking for...
=SUMPRODUCT(--ISNUMBER(SEARCH(X2,CompoundRange))) where X2 houses the string condition of amino? LeicaElmar wrote: I;m new here and need help with something. We are counting chemical compounds and need a way to count two columns. One column tells the group it originated.Another says yes or no if it has been ordered. I am using COUNTIF to count particular groups in both of those columns. For example, COUNTIF counts the number of yes to tell us which unique compound has been analyzed. Theother may have the compound 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 where *Amino* is located, we want it to increase the count of amino in our list. I;m lost on this and hope someone can help. Doing this helps to make keeping a count easy rather than going in periodically and physically counting the "Amino" and each row that has a yes. thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Counting filled cells in excel | Excel Worksheet Functions | |||
how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
how do i get more than three conditional formats in excel | Excel Worksheet Functions | |||
Is it possible to do a conditional subtotal in Excel? | Excel Worksheet Functions |