Why won't this work? Trying to count cells that have "TEST" in column B and if it has a "Y" in the range from columns D to G....
=COUNTIFS(B2:B200,"TEST", D2:G200, "Y")
I need the second criteria to be across a range of columns where it equals "Y" and I get error this way. If I only look in one column (e.g. D) it works fine and returns the count.
Hoping someone can help. Thanks...
Bookmarks