How to calculate number of request per month and status?

iamje

Hi,

Data are:

Requested date formatted as 12/01/21 and Status such as New, In-Progress and Complete. Now I would like to calculate how may request do I have per month and the corresponding status. So basically considering only open requests.

thank you in advance for your help.

Paul Newcome

Assuming that by "open" you mean not "Complete", try this...

=COUNTIFS([Date Column]:[Date Column], AND(IFERROR(MONTH(@cell), 0) = 12, IFERROR(YEAR(@cell), 0) = 2021), Status:Status, @cell <> "Complete")

You would just need to change the bold numbers to match whichever year and month you are wanting to count for.