Problem adding countifs

KWright84

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.

Nic Larsen

This worked for me:

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

KWright84

Thanks so much! That also worked for me.