Countifs forumla with 3 criteria's

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?

Find more posts tagged with

Formulas

Solution Center

Cell linking

Accepted answers

All comments

Paul Newcome

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

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.