Thread: Conditional Count

Hello,

I am using the following forumula to count the number of "X" in J when "T3A3" is in F on the same line and it works fine

=SUMPRODUCT((AM!F13:F240="T3A3")*(AM!J13:J240="X"))

Now i only need to count the X if a code in a list of codes held in sheet codelist cells A1 to A10 is entered in row H

how do i do this

Many thanks

How would I do that can you give me an example please

Originally Posted by stoney1977

Now i only need to count the X if a code in a list of codes held in sheet codelist cells A1 to A10 is entered in row H

Elaborating on JR's post:

=SUMPRODUCT(ISNUMBER(MATCH(AM!$H$13:$H$240,codelist!$A$1:$A$10,0))*(AM!$J$13:$J$240="X"))