COUNTIF Checkbox Help!

Amy Shank

Help!!! I'm trying to create a formula that counts a row if a column "A" value =X AND column B check box is checked.

I have tried the following and it does not work. Any suggestions?

=COUNTIF(Status:Status, OR(@cell = "Partially Invoiced", @cell = "Cancelled", @cell = "Contract Requested", @cell = "Contract with Client for Signature", @cell = "Proposal Development", @cell = "Proposal with Client", @cell = "Declined", @cell = "Under Revision", @cell = "Request Received/Documented", ([Proposal Team Project] @row, 0)))

Andrée Starå

Hi @Amy Shank

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Amy Shank

Hi There,

We have a large sheet that tracks each step of the process for our Contracts & Proposals. I would like to create a graph that captures how many of our contracts are active by status. In order to do this I need to eliminate those contracts that are checked. I'm pulling data from two different columns. One column is "Complete" checked yes or no. The other column is the contracts status. I already have formulas to pull each status but I need to subtract those from the "Complete" Column that are not checked.

I also need to be able to right a formula that will count each contract if the box IS checked.

Additionally I would need a formula that removed the budgeted dollar amounts (yet another column) associated with the boxes that are checked.

Tricia Banks

Here is what we need help with:

=COUNTIF(Status:Status, OR(@cell = "Partially Invoiced", @cell = "Cancelled", @cell = "Contract Requested", @cell = "Contract with Client for Signature", @cell = "Proposal Development", @cell = "Proposal with Client", @cell = "Declined", @cell = "Under Revision", @cell = "Request Received/Documented", ([Proposal Team Project] @row, 0)))

1. Our "Status" column formula is working fine; however, we are try to "exclude" any row "checked" under the "Proposal Team Project" column.

Thank you!

Paul Newcome

@Tricia Banks Try this...

=COUNTIFS(Status:Status, OR(@cell = "Partially Invoiced", @cell = "Cancelled", @cell = "Contract Requested", @cell = "Contract with Client for Signature", @cell = "Proposal Development", @cell = "Proposal with Client", @cell = "Declined", @cell = "Under Revision", @cell = "Request Received/Documented"), [Proposal Team Project] @row, 0)

Tricia Banks

Did not work. Getting that "fun" #UNPARSEABLE error message. Any other suggestions?

Paul Newcome

Sorry about that. Try this one...

=COUNTIFS(Status:Status, OR(@cell = "Partially Invoiced", @cell = "Cancelled", @cell = "Contract Requested", @cell = "Contract with Client for Signature", @cell = "Proposal Development", @cell = "Proposal with Client", @cell = "Declined", @cell = "Under Revision", @cell = "Request Received/Documented"), [Proposal Team Project]:[Proposal Team Project], 0)

Tricia Banks

Yay!!!! You rock! Thank you!

Paul Newcome

Happy to help. 👍️

Andrée Starå

@Amy Shank & @Tricia Banks

Happy to help!

I saw that Paul answered already!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD