COUNTIFS with

Cristian

Hello

This formula works great but now I want to add another parameter to just provide me with those entries marked as P and A.

Here's the formula that works so far:

=COUNTIFS({Date Created}, >=[Count Range Start]@row, {Date Created}, <=[Count Range End]@row)

Here's what I want to add:

{Type}, OR(@cell="P", @cell="A" )

Where can I add this formula? Can add it within the COUNTIFS formula or do I start with an IF statement but not sure how to add that.

Thanks

Paul Newcome

You would add what you have directly into the COUNTIFS as another range/criteria set.

Cristian

Thanks Paul. For some reason I was having problems before but now it's working. Thanks again.

Paul Newcome

Happy to help. 👍️