IF Statement?

Kelly R.

Can someone help me with this formula please.

I have a monthly request list with open tasks. At the end of the month (example: February 28th), I need to calculate how many requests were still open at that time. I am trying to incorporate the date opened with the request status of Open by the Month using an IF statement - maybe it should be COUNTIF. By the information below, it would appear there are 7 requests still open but I cant figure out how to populate the formula. Any help is appreciated.

Thank you!

Danielle Arteaga

Not sure how you have your columns formatted, so there may be more efficient way to go, but I think this will work for you:

=COUNTIFS([Request Status]:[Request Status], "Open", [Month Opened]:[Month Opened], "2")