VLOOKUP within COUNTIFS not capturing all occurrences I have a formula to count

Question

VLOOKUP within COUNTIFS not capturing all occurrences

I have a formula to count occurrences of worksheet rows where certain conditions are met:

=COUNTIFS(G2:G56,"IT",B2:B56,"Partially Implemented",H2:H56,VLOOKUP("*Security*",H2:H56,1,FALSE))

Column G must contain the word "IT"

Column B must contain the words "Partially Implemented"

Column H must contain the word "Security"

Column H rows that contain the word Security have values of "Information Security" as well as "Information Security, Compliance" as well as "Information Security, Oversight".

The result of the formula picks up only the count of rows where column H has a value of "Information Security". It does not pick up occurrences of the other 2.

How can I change this formula to capture all of them??

Thank you !!

Explanation / Answer

Hi..

Try this,

=COUNTIFS(G2:G56,"IT",B2:B56,"Partially Implemented",H2:H56,"*Security*") ;

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.