Stumped: COUNTIF Formula for 4 criteria and 2 ranges.

Rhonda B.

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

Welcome @Rhonda B.

Try

=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.

Rhonda B.

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

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")