CountIfs / OR Function for Sheet Summary Formula

justdan2

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

Thanks for your help.

Paul Newcome

Try this:

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

Razetto

@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.

justdan2

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?

Paul Newcome

Try this:

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

DKazatsky2

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

Debbie C.

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"))

Paul Newcome

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

Debbie C.

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

justdan2

Thanks Paul, that revised formula worked for me.

Paul Newcome

Happy to help. 👍️