COUNTIF With Parameters in Two Columns

jcurry

I am trying to create a formula that will count the number of status of 24-72 for the month of Oct 22. I have tried a number of iterations without success.

Example formula tried (yields unparseable)

=COUNTIFS([Month Year]:[Month Year], "Oct 22", [Status:Status], "24-72")

Sheet info

Cory Page

Good morning,

Are you looking for something like I have shown below if not feel free to reply..

=COUNTIFS(Status:Status, ="24-72", [Month Year]:[Month Year], "Oct 22")

Here is a view if you would like a static summary sheet as well.

=COUNTIFS(Status:Status, =[Status (Summary Sheet)]@row, [Month Year]:[Month Year], [Month Year (Summary Sheets)]@row)

Paul Newcome

Try removing the square brackets from around

[Status:Status]

should be

Status:Status

jcurry

Thank you, both!! Removing the brackets was the key. Now I will dig into the version that Cory provided.

Paul Newcome

Happy to help. 👍️