COUNTIFS function in Excel with dates by Chris Menard

[@jmburk55]

Your video was the 5th one I watched trying to do what looks so simple. Thank you!

[@ChrisMenardTraining]

You’re welcome 😊

[@shadbir]

Dear, how to find a specific value from a date range.. Like, I want to find the total number of "Incoming calls" value from 11th Jan to 20 Jan..

[@ChrisMenardTraining]

You could use Countifs for that, but I would filter by date in that example.

[@kellyw4922]

How do I find a total number of cells that have dates in it, but excluding any cells that read "not open"?

[@ChrisMenardTraining]

Do the cells that have dates, also have numbers? For example, B2: B70 has dates and "not opened" in them. You could just use =COUNT(B2:B50) to find the cells with dates. Now, if some of them have numbers, that would throw it off.

[@jollipetdrive3660]

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

[@ChrisMenardTraining]

Add a helper column and use A2 = B2 then do the COUNTIF Function drive.google.com/file/d/1VMmBfCfuKBHQOw5TtP3upHxtErnd17Ef/view?usp=drivesdk

[@StevieC82]

I have a table with a range of dates in one column and names in another. how can I count the number a name appears for each month?

[@ChrisMenardTraining]

Use a PivotTable Here is a screenshot drive.google.com/file/d/1Jh_YTdAndrxx1TcamVu8h8kZl62p4OGY/view?usp=drivesdk

[@VictorFigueroa-t1e]

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

[@crisjohnjimenez5905]

What if I want to count a product within the day

[@CategoricalImperative]

Anyone else have the habit of forgetting the comma, then spending FOREVER trying to figure it out? lol

[@davidbell8819]

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!

[@ChrisMenardTraining]

You're very welcome! Thanks, David.

[@keatitan6648]

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.

[@ChrisMenardTraining]

You're welcome!

[@RebeccaDonnelly-w4x]

Hi, I know this is 3 years old however when I follow the date calculations, for some reason it doesn't add up the end of month (31/05/2023) for example, so the total is 52 on my master sheet, but the total is coming up 49 because 3 of those are dated 31/05/2023. I've followed step-by-step but it's still not adding the last day of the month. Any advice?

[@shiffamohammed5818]

very good content presented nicely. Thank you so much.

[@ChrisMenardTraining]

You are most welcome

[@pacman.96]

THANK YOU BOSS!

[@ChrisMenardTraining]

Glad to help.

[@rafasoares7]

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

[@ChrisMenardTraining]

Glad to help. Thanks, Rafael.

[@ckaz7678]

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

[@ChrisMenardTraining]

You are welcome.

[@TheUnknownGamer1162]

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.

[@dhruvikghadiya9412]

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.

[@matthoyle951]

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?

[@sourrabhaggarwal8887]

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.

[@vangieevangelista9488]

I tried the formula why is it the returning value is a date instead the count

[@ChrisMenardTraining]

Can you change the formatting of the answer? See if that works. Let me know.

[@alanh.711]

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

[@ChrisMenardTraining]

Thank you. You have a good point about the dates, they work with Sumifs also.

[@stevenrichards9272]

Hi, great video. I am wondering if you can help with a problem I have. I want to wrote a formula which will count the last ten days from the current date where the current date is dynamic and changes each day. I want to do this so that I can record the formula as a macro Can you help with this?

[@ChrisMenardTraining]

=today()-10 will give you 10 days from the current date.

[@stevenrichards9272]

@@ChrisMenardTraining thank you

[@thtgrldiana6388]

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. 🙂

[@syedashfaq7245]

How can I count only cells which is just before and after a particular cell

[@63wpeteronyegbule68]

You're the BEST. LIFE SAVER!

[@ChrisMenardTraining]

Glad to help!

[@Natalie-gn6nt]

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 😁😁

[@waqasshamas]

You saved my day, Allah bless you with real worth

[@ChrisMenardTraining]

Thank you.

[@amolarunparihar9846]

How to find out in first column Cell A1 - R100 ,B1- Match, Cell A2 - R100 , B2 - Not Match Cell A3- R200, B3 - Not Match Cell A4 R300, B4 - Not match Cell A5 R300,B5 - Not match How to find out only Not match result by formula when there all results are not match

[@jayjoelymadelo4150]

Its really helpful. Thank you so much

[@ChrisMenardTraining]

Most welcome!

[@MohamedAmr-n8q]

You are a life saver! , Thank you so much

[@yoyara97]

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

[@Mr_Melo]

Can I contact you to help me create a formula?

[@keiilala]

Well-explained! Thank you!

[@ChrisMenardTraining]

You're welcome!

[@sovannetmeas]

Thank you so much

[@ChrisMenardTraining]

You're most welcome

[@mahmoudbahaa3062]

brilliant video

[@ChrisMenardTraining]

Glad you enjoyed it

[@hirengajaria]

Thank you

[@ChrisMenardTraining]

Welcome!

[@saaduddin6781]

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

[@MEETMEKANNAN]

Thanks Chris

[@joshualeonricardo]

THANK YOU!!!

[@CPAJayhawk]

Thank you

[@ChrisMenardTraining]

Welcome

[@itsmetinnie1685]

great video sir

[@ChrisMenardTraining]

Thank you Christine

[@itsmetinnie1685]

@@ChrisMenardTraining thanks for the notice sir. More videos please

[@amyjain97]

Hey Chris, how do we get the numbers for particular qtr, like for any current qtr and this should also change as and when we move to new qtr

[@Pankaj-Verma-]

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

[@ChrisMenardTraining]

Thank you!