Count number of matches within a range of specific criteria

[cgebke]

I am trying to count the number of matches between tworanges (column A and L). The hard part is I need the ranges to first be sortedbased on certain criteria.
Now I know the basic matching formula I know is
=SUMPRODUCT(COUNTIF(A2:A2000,L25:L5000))

The below formula counts the number of rows given the criteriaI am trying to work within
=SUM(COUNTIFS(G:G,"E1",W:W,"3D",AS:AS,{"11","2C","2N","B1","C7","CF","KM"}))

I am trying to somehow look at column A and L within thecriteria above and count the number of matches there are.
Any assistance would be appreciated.

 

[Marcelo Branco]

I'm not sure i understand what you are trying to do.

See if this array formula is OK
=SUM(IF(ISNUMBER(MATCH(L25:L5000,IF(G2:G2000="E1",IF(W2:W2000="3D",IF(ISNUMBER(MATCH(AS2:AS2000,{"11","2C","2N","B1","C7","CF","KM"},0)),A2:A2000))),0)),1))
Ctrl+Shift+Enter

If it's not what you want, try showing us a small sample of your data along with the expected result.

M.