# CountIfs / OR Function for Sheet Summary Formula

Options
✭✭✭✭

Hello,

I am trying to create a sheet summary formula that counts status columns if it meets the following criteria. However, I using this OR function doesn't work:

=COUNTIFS(Status:Status, "1. Qualification", OR(Status:Status, "2. Proposal / Tender", OR(Status:Status, "3. Waiting for Deposit")))

Is there way to achieve this as the formula above pulls back: Invalid Data Type

Tags:

• ✭✭✭✭✭✭
Options

Try this:

=COUNTIFS(Status:Status, OR(@cell = "1. Qualification", @cell = "2. Proposal / Tender", @cell = "3. Waiting for Deposit"))

• ✭✭✭✭✭✭
Options

@justdan2 Your formula is missing the reference @cell as in =COUNTIFS(Status:Status, @cell="1. Qualification",... and I think you only need one OR in it.

• ✭✭✭✭
Options

Hi Razetto, thanks for your comments. I've updated the formula which now does not return an error but returns '0', despite there being 2 x "1. Qualification" and 33x "Proposal / Tender" values.

I've checked the spellings and both are correct. Is there anything missing?

• ✭✭✭✭✭✭
Options

Try this:

=COUNTIFS(Status:Status, OR(@cell = "1. Qualification", @cell = "2. Proposal / Tender", @cell = "3. Waiting for Deposit"))

• ✭✭✭✭✭
Options

Hi @justdan2 ,

Give this a try. =COUNTIF(Status:Status, OR(@cell = "1. Qualification", @cell = "2. Proposal / Tender", @cell = "3. Waiting for Deposit"))

Hope this helps.

Dave

• ✭✭✭
Options

Did this work for anyone?

Does this work in a Sheet summary scenario?

=COUNTIF(Status:Status, OR(@cell = "1. Qualification", @cell = "2. Proposal / Tender", @cell = "3. Waiting for Deposit"))

• ✭✭✭✭✭✭
Options

@Debbie C. It should work. Have you tried it and come across an issue?

• ✭✭✭
Options

Thanks for the follow up. 10 minutes after I asked the question, I rebuilt the function and it worked.

• ✭✭✭✭
Options

Thanks Paul, that revised formula worked for me.

• ✭✭✭✭✭✭
Options

Happy to help. 👍️