Hello! I need help with a formula, experience with Countifs OR AND formula?

Paola Preciado

I am not sure if I am doing this right, I need to count "reference another sheet" if status is closed, completed OR sent to contractor (any of them), AND program is "APD".

Here is my formula:

=COUNTIFS(OR({Classification Review Status}, "Completed", {Classification Review Status} = "Closed", {Classification Review Status} = "Sent to contractor"), AND({Classification Review Program}, "APD"))

It says Invalid Data Type, I am not sure if I can use this formula when reference to another sheet

Kelly Moore

Hey @Paola Preciado

Try this

=COUNTIFS({Classification Review Status},OR(@cell= "Completed", @cell= "Closed", @cell= "Sent to contractor"), {Classification Review Program}, "APD")

Will that work for you?

Kelly

Paola Preciado

That worked! Thank you So much Kelly!

Paola