Can you create a COUNTIF formula with 3 columns?

stephcorporate

In a separate metrics sheet, I am trying to count the number of pregnancy studies qualified in the month of October.

I want to formula to count the row if the column contains:

• Type of Study contains "Pregnancy"
• Phase = "Qualified"
• Month Name Identifier (Helper Column) = 10

Carson Penticuff

You will need to set up references to point to your source sheet, then this should work.

=COUNTIFS({Type of Study]}, HAS(@cell, "Pregnancy"), {Phase}, "Qualified", {Month Name Identifier (Helper Column)}, VALUE(@cell) = 10)

Carson Penticuff

You will need to set up references to point to your source sheet, then this should work.

=COUNTIFS({Type of Study]}, HAS(@cell, "Pregnancy"), {Phase}, "Qualified", {Month Name Identifier (Helper Column)}, VALUE(@cell) = 10)

stephcorporate

@Carson Penticuff Thank you so much! I really appreciate it. This worked!

Carson Penticuff

👍