Adding a third scenario to a countifs formula

[squeakums]

I need your help adding a third scenario to this countifs formula:


=COUNTIFS(Details!C:C,"Out of Compliance Contracts", Details!A:A,IF($C$5="Grand Total","?*",$C$5))

Need to add also if D:D,"CURRENT MONTH"

 

[Special-K99]

You've already got two conditions in there so you must know how to add further conditions. Just add the third like you added the second, simple

=COUNTIFS(Details!C:C,"Out of Compliance Contracts", Details!A:A,IF($C$5="Grand Total","?*",$C$5),D:D,"CURRENT MONTH" )

 

[squeakums]

That works, thank you much