Count how many "On Hold" projects for the Sheet Summary

Lula05

I have a sheet set up with a (Multi Select) dropdown, and a complete check box, & would like to get a count of how many projects that are NOT complete & are On Hold.

COLUMN: Info Still Needed - is a multi select dropdown

COLUMN: Complete - is a check box

I have tried several formulas with no luck. =COUNTIF(complete:complete, 0, Info Still Needed:Info Still Needed, "On Hold") =COUNTIF([complete]:[complete], 0, [Info Still Needed]:[Info Still Needed], "On Hold") =COUNTIF([Info Still Needed]:[Info Still Needed], HAS(@cell, "On Hold"),[complete]:[complete], 0)

am I even close? Are the Formulas in the Sheet Summary a little different that the worksheets themselves?

Based on the screen shot the Sheet Summary should give me a count of "3" for the number of projects on hold, but I would also like to get a quick summary of how many projects I still need the composite rate for"5", or the contract amount"3".

Bassam Khalil

Hi @Lula05,

Hope you are fine, please try the following formula:

=IFERROR(COUNTIFS([Notes Info Still Needed]:[Notes Info Still Needed], CONTAINS("On Hold",
@cell), Complete:Complete, @cell = 0), "")

the following screenshot shows the result: