COUNTIFS function in Excel with dates by Chris Menard

To count the number of occurrences for a range or multiple items use the COUNTIFS function. When it comes to a date range, whether is it for a month, quarter, or any date range, the COUNTIFS function is what you need. Examples:
How many orders did we get for Quarter 1? That is the COUNTIFS function since it is between a range of dates.
How many times was product A ordered for customers in Australia?
How many orders did we have between January 1 and March 31?

The COUNTIF function, which I covered in this video, will handle one criterion. COUNTIFS handle multiple criteria.

TimeStamps:
01:07 Countif function
02:30 Countifs with text.
03:50 FormulaText function
04:37 Countifs with dates method 1
07:40 Countifs with dates method 2
10:20 Countifs with dates method 3 using EOMONTH function

In this video, I'll show three methods for doing Countifs between dates.
Method 1 is typing the date in the function
Method 2 is typing a Start and End date and using concatenate in Excel to join COUNTIFS with the cell reference.
Method 3 is using the EOMONTH function in Excel.

#msexcel #excel #exceltraining #countifsexcel #excelcountifs

Chris Menard's website:

Upcoming live event:
Chris Menard will speak to the DeKalb Chapter of CPAs, part of the Georgia Society of CPAs on February 25, 2020. Menard's presentation will be Excel Analysis and PivotTables.

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[davidbell]

You're excel-lent! Thank you so much, I've spent ages reading through so much jargon to finally get to your brilliant video. Saved me!

[TheUnknownGamer]

Thank you for explaining it in such an easy way. I was working on data but was confused about using Countifs function when working with dates. But your video helped me out. Thank you so much, Chris.

[Natalie-gnnt]

Thankyou so much for posting this, you are a great teacher and made it so easy to understand!!
I never got to learn any of this in school and am currently trying to self learn some functions for a project I’m doing. Right now I am so happy because I just learnt to do something I thought was outside of my capabilities and it’s thanks to you 😁😁

[keatitan]

Thank you so much Chris! This is the only place on the internet I could find the method you used! Hope you are doing well.

[rafasoares]

omg, you saved so many hours of my life. thank you!

[waqasshamas]

You saved my day, Allah bless you with real worth

[alanh.]

Great work. The date formula explanation was brilliant. Used that with sumifs formula.

[MohamedAmr-nq]

You are a life saver!, Thank you so much

[ckaz]

great video, thanks for this. And thanks for showing your least favorite method, it's the one I was looking for!👍

[shiffamohammed]

very good content presented nicely. Thank you so much.

[saaduddin]

Thank you, did not know that you had to concatenate to do dates that way.

[Pankaj-Verma-]

It is always so fantastic to watch you, Chris.
Thanks a lot, sir.

[dhruvikghadiya]

Thanks a lot for sharing amazing lesson about the excel formula.
May i please request you to share the formula with same example that how to count AU in collumn E if in collumn D has mentioned date has January month.

[thtgrldiana]

Hi, Thank you for your knowledge sharing! I am managing help desk tickets. I want to perform a calculate function that tells me how many tickets were created on a specific day. I want to show this calculation for each calendar day where an incident was created. I have several columns: I have an INC number column, Date created, Date closed. the date columns are formatted as 01/01/2021 (mm/dd/yyyy). I also want to perform this calculation/function in a seperate worksheet. It seems counting date occurrences are not as straight forward as other sum/count functions. The basic Count/countIf functions are not working and I couldn't figure out how to implement your solution either... please help. 🙂

[crisjohnjimenez]

What if I want to count a product within the day

[sourrabhaggarwal]

Hi can you please tell me how can we calculate number of customer for a particular date suppose I want to calculate number of customers added on the 2/1/2021 using count if function.

[matthoyle]

I have a table and want to count the number of cells in a column with specific text but only if the dates in another column are between 2 dates - basically if it says "Booked On" and is in January or February and so on. Any ideas?

[jollipetdrive]

Hi Chris, how do you do a countif function for if the (exact auction date = exact sale date = count 1)

[yoyara]

What if I want to know how many a's are between a date range?

[ujoevqe]

I have been looking to find out how I can countifs dates grater than "today" based on 2 criteria 1st: country code equal to GB and 2nd criteria: product equal to C