countif with more than 2 searches

[mattress58]

This works. It looks for two values in different colums.

Please Login or Register  to view this content.

which is the same as
=COUNTIFS(A7:A1260,"WC", AB7:AB1260,"Y")
in cell D2

but when I try looking for 4 values it comes back as unable to get the CountIfs property of the worksheetfunction class

Please Login or Register  to view this content.

this one is the same as

=COUNTIFS(A7:A1260,"WC", AB7:AB1260,"Y", AB7:AB1206,"Y", F7:F1260,"3",G7:G1260,G7)
in cell D2

[daffodil11]

There's a typo in your code.

You begin with ranges of 1206 and then you switch to ranges of 1260.

[mattress58]

oHHHHHHHHHHHHHHHHHHHHHHHHHHHH MYYYYYYYYYYYYYYYYYY...... You are Correct............... I have been trying to figure this out for 2 hours. Good eye.......

[daffodil11]

Pro tip: use line breaks in your code to make troubleshooting easier.

Please Login or Register  to view this content.

Much easier to read!

Coincidentally, also can be done in spreadsheet land with liberal use of Alt+Enter

Please Login or Register  to view this content.