Problem adding countifs

Options
KWright84
KWright84 ✭✭
edited 12/09/19 in Smartsheet Basics

I'm trying to count projects that have either a four or five priority and this formula works:

=SUM(COUNTIF({PLT Project Roadmap Range 17}, "Four"), COUNTIF({PLT Project Roadmap Range 17}, "Five"))

 

I want to count projects with either a four or five priority that start either today or in the past and this formula doesn't work:

=SUM(COUNTIFS({PLT Project Roadmap Range 17}, "Four", {PLT Project Roadmap Range 20} <= TODAY()), COUNTIFS({PLT Project Roadmap Range 17}, "Five", {PLT Project Roadmap Range 20} <= TODAY()))

I'm getting #INVALID OPERATION and I'm not understanding why. Does anyone have any idea?

 

This COUNTIFS formula is working:

=SUM(COUNTIFS({PLT Project Roadmap Range 17}, "Four", {PLT Project Roadmap Range 14}, >31), COUNTIFS({PLT Project Roadmap Range 17}, "Five", {PLT Project Roadmap Range 14}, >31))

 

I don't understand why I can't add the <=TODAY() as an additional IF.

Comments