Countif, index and match


C

CAD

Right now I have the below formula that takes whatever is in K9, finds the respective column in an array and counts anytime there is a number greater than 4 in that column.

I'm having trouble adding another criteria to the formula. So that in addition to anything that is greater than 4 in that column, I want to count only the rows where column T equals "X" value. So for example out of 10 unique rows, 5 have "X" and the other 5 have "Y", I would want to add to the below formula to only count where column T = "X".

=COUNTIF(INDEX(P2:T16,0,MATCH(K9,P1:T1,0)),">=4")

Thanks for any help

CAD
 
Ad

Advertisements

C

Claus Busch

Hi,

Am Wed, 10 Jul 2013 11:34:48 -0700 (PDT) schrieb CAD:
Right now I have the below formula that takes whatever is in K9, finds the respective column in an array and counts anytime there is a number greater than 4 in that column.

I'm having trouble adding another criteria to the formula. So that in addition to anything that is greater than 4 in that column, I want to count only the rows where column T equals "X" value. So for example out of 10 unique rows, 5 have "X" and the other 5 have "Y", I would want to add to the below formula to only count where column T = "X".

=COUNTIF(INDEX(P2:T16,0,MATCH(K9,P1:T1,0)),">=4")
try:
=SUMPRODUCT(--(INDEX(P2:T16,,MATCH(K9,P1:T1,0))>=4),--(T2:T16="X"))


Regards
Claus B.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index/ Match 1
Index, Match?? 1
index and match 11
countif partial match 3
Index Match Functions 1
Match/ Index question 2
index/match help 1
Vlookup, Index or Match - Problem 2

Top