Countifs with multiple, multiple criteria

[Plukey]

=COUNTIFS(Mondays_Report[PLN Complete],"no",Mondays_Report[AOR],H3,Mondays_Report[PLN-BD SchFin],"<"&TODAY())+COUNTIFS(Mondays_Report[PLN ActFin],"<>"&"",Mondays_Report[AOR],H3,Mondays_Report[PLN-BD SchFin],"<"&TODAY())

Current formula works as it should, but.. Now i need to add one more criteria & i cant figure it out for nothing.

I need to add another cell reference to filter on...as of now Im filtering on [AOR] now i also need to filter on [BLOCK]

 

[Fluff]

Maybe

=COUNTIFS(Mondays_Report[PLN Complete],"no",Mondays_Report[AOR],H3,Mondays_Report[BLOCK],G3,Mondays_Report[PLN-BD SchFin],"<"&TODAY())+COUNTIFS(Mondays_Report[PLN ActFin],"<>"&"",Mondays_Report[AOR],H3,Mondays_Report[BLOCK],G3,Mondays_Report[PLN-BD SchFin],"<"&TODAY())

 

[Plukey]

Maybe

=COUNTIFS(Mondays_Report[PLN Complete],"no",Mondays_Report[AOR],H3,Mondays_Report[BLOCK],G3,Mondays_Report[PLN-BD SchFin],"<"&TODAY())+COUNTIFS(Mondays_Report[PLN ActFin],"<>"&"",Mondays_Report[AOR],H3,Mondays_Report[BLOCK],G3,Mondays_Report[PLN-BD SchFin],"<"&TODAY())

ABSOLUTLEY perfect...! May I ask one more favor? help with incorporating (G3) in the next two formulas?

=COUNTIFS(Mondays_Report[PLN ActFin],"<>"&"",Mondays_Report[AOR],H3)

=COUNTIFS(Mondays_Report[PLN Complete],"",Mondays_Report[AOR],H3,Mondays_Report[PLN-BD SchFin],"<"&TODAY())

 

[Fluff]

Just add that the same way I did.

 

[Plukey]

Just add that the same way I did.

Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[smozgur]

ABSOLUTLEY perfect...!

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.