Countifs on percent complete, month, and year

Paul F

Is it possible to create a countifs statement like the following: =COUNTIFS([% Complete]:[% Complete], =1, [Project Finish]:[Project Finish],AND(IFERROR((YEAR(@cell), 0) = 2018),IFERROR((MONTH(@cell), 0) = 2)) ?  I am trying the following equation to search for 100% complete and during a specified month and year.  I am getting a #unparseable error when tying the equation.  I have success with a similar equation: =COUNTIFS([% Complete]:[% Complete], =1, [Project Finish]:[Project Finish], IFERROR(YEAR(@cell), 0) = 2017)

Schiff A.

Hello,

The issue here is that you're including an AND function within your formula.

When using the COUNTIFS there is an implied AND between each range/criteria combination so you do not need to use an AND function, simply add another range/criteria set.

Your final formula will look like this:

=COUNTIFS([% Complete]:[% Complete], =1, [Project Finish]:[Project Finish], IFERROR(YEAR(@cell), 0) = 2018, [Project Finish]:[Project Finish], IFERROR(MONTH(@cell), 0) = 2)

 

Thanks!

Schiff

Smartsheet Support

Paul F

Schiff, thanks, works perfectly now!