Can you create a COUNTIF formula with 3 columns?

edited 10/18/23 in Formulas and Functions

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

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    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)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!