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

这工作对我来说:

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

KWright84

Thanks so much! That also worked for me.