Formulas to Create a Summary Count by Month with COUNTIFS Function

Here, we will see the simple formula used to create a summary count by month with COUNTIFS Function in Excel Office 365. Let’s get started!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Formulas to create a summary count of the month with COUNTIFS

General Formula:

• The below formula will help to create a summary count by month with COUNTIFS Function.

=COUNTIFS(dates,”>=”&A1,dates,”<“&EDATE(A1,1))

Syntax Explanations:

• COUNTIFS – In Excel, this function will help to count the number of cells that meet multiple conditions or criteria.
• EDATE -The** EDATE Function** adds or subtracts the specified number of months with the given date and returns the serial number that represents the result date.
• Comma symbol (,) – It is a separator which helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.
• Criteria (A1) – It is the condition that is used to count the dates.
• Dates – It represents the input dates.

Examples:

Example 1:

• In the below image we will show how to create a summary count of the month with the COUNTIFS function.
• First, we will give the input ranges in Column B and Column C.
• After that, enter the given formula.
• Finally, it will display the result of the summary count of the month in the selected Cell F4.

Example 1

Example 2:

• To create a summary count by using priority, we need to extend the criteria (Select the date and priority columns).
• Refer to the below screenshot.
• Here, we have added criteria in Column D.
• Then, add the priority range to the formula.
• After that, you can get the result as shown below.

Example 2

Conclusion:

From this article, you can get to know the formulas for creating a summary count by month with COUNTIFS Function in Excel Office 365. Hope that this article is useful to you. If you have any doubts/queries, feel free to share it with us.

Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!! *and Excel Formulas *!!

Read Also:

• Formulas to Extract Numbers From Mixed Text String with Function!!
• Formulas to Count Unique Text Values in a Range in Excel Office 365!!
• Excel Formulas for Calculating Age by Date of Birth ~ Easy Guide!!
• Excel Formulas to Count Long Numbers Without COUNTIF Function!!