Stumped: COUNTIF Formula for 4 criteria and 2 ranges.

Hello! This is my first time utilizing the Smartsheet Community 😊

 I am trying to develop a report that highlights the number of requests across four different categories (RFPs, New Programs, Funding Rounds, and Rolling Applications) within four fiscal quarters.

So ideally, I want a formula on my sheet summary to tell me:

  1. How many requests per category in Q1, Q2, Q3, and Q4.

I want to note that the range includes two columns: Type and Fiscal Quarter.

 Any suggestions on the formula would be very helpful! 


  • KPH
    KPH ✭✭✭✭✭✭

    Welcome @Rhonda B.


    =COUNTIFS(Type:Type,"RFP",[Fiscal Quarter]:[Fiscal Quarter],"Q1")

    Type:Type means the entire column called Type

    For Fiscal Quarter we need to use the square brackets as there is a space in the name

    You do not need parenthesis around the things to count.

  • I appreciate the help! Unfortunately, that did not work. It says #Invalid Data Type. Also I don't think this formula accounts for all four categories: RFP, New Programs, Funding Rounds or Rolling Applications. Would I just copy and paste the original formula three other times?

  • MariaCurtis
    MariaCurtis ✭✭✭✭✭
    edited 03/16/24

    Interesting! That's the exact formula I used and it worked for me.

    What are your column types? Both of mine are drop-downs. Not sure if that matters.

    Also, to address your question about the other types:

    • If you wanted this particular Summary to count just the RFPs, then this is the formula you would use.
    • If you wanted this formula to count ALL Q1 requests, regardless of type, then you just need a simple =COUNTIF([Fiscal Quarter]:[Fiscal Quarter], "Q1")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!