Countifs forumla with 3 criteria's

Reuben M

I'm have used a countifs formula to count the total number of jobs per month that have been launched in my business using the following formula:

=COUNTIFS({Project Launch Input 2021+ Range 3}, >=DATE(2022, 6, 1), {Project Launch Input 2021+ Range 3}, <=DATE(2022, 6, 31))

I now what to be able to count the number of jobs per month that have been launched depending on the status. So I would like to count the number of jobs per month that have been launched if the status is "Successful".

I've tried a variety of different approaches to have a formula that would work for this but have had no look, can anyone assist?

Paul Newcome

You would continue with the same syntax that you have been using in your COUNTIFS.

=COUNTIFS(range, criteria, range, criteria, range, criteria)