Count if on two columns

I have a sheet that pulls from another, I need to do a count if for two different columns. I use this formula for one, how do I add another?

=COUNTIF({Date 2}, [Start Date]@row)

I need something like: =COUNTIF({Date 2}, [Start Date]@row), =COUNTIF({Review Board}, [ReviewBoard]@row=XX)

It is an agenda sheet that has a set number of minutes, then I subtract minutes based on the number of topics added for that date. Now I need to also do a type of lookup for the Review Board. There are three Review Boards and in many cases the dates are now the same.


Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    edited 01/08/22 Answer ✓

    Hey Leann

    The syntax is correct. When you entered it into your destination sheet - did you get what you expected?

    oops you forgot an @row

     =COUNTIFS({Date 2}, [Start Date]@row, {Review Board}, [Oncology TAG]@row)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!