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

Thanks for your help.

Tags:

Best Answer

Answers