Excel SUMIFS Date Range Formula | Sum between dates & sum with multiple criteria

Поделиться
HTML-код
  • Опубликовано: 25 июл 2018
  • Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
    Discover how to sum values between two dates, for a month, and with multiple criteria. You'll also learn how to sum values within a month. For example, your data set contains dates and you'd like to create a monthly report where you show the total value for the month, you can use the SUMIFS function together with the EOMONTH (end of the month Excel formula).
    ⬇️ Download the workbook here: pages.xelplus.com/sum-between...
    Key Focus:
    ▪️ Sum Between Dates: Learn to use SUMIFS for specific date ranges.
    ▪️ Monthly Totals: Find out how to sum revenue for entire months.
    ▪️ Advanced Criteria: Add extra conditions like app categories for detailed analysis.
    👨‍💻 Inside the Tutorial:
    ▪️ SUMIFS Formula: Easy-to-follow guide on arguments like sum range and criteria.
    ▪️ Date Ranges: Tricks to select the right dates using functions and formatting.
    ▪️ Helper Cells: Use EOMONTH and other formulas for precise calculations.
    ▪️ Extra Tips: Formatting and checking results to ensure accuracy.
    Use the Excel SUMIFS formula to sum values between two dates.
    Here you'll need to use the greater than & less than operators inside the SUMIFS formula.
    Last, you'll learn how to add more criteria to your sum range. For example, you'd like to sum values between two dates and also account for one or more additional criteria.
    Happy learning!
    ★★ Links to related videos: ★★
    SUMIFS, COUNTIFS & AVERAGEIFS Basic introduction: • How to Use SUMIFS, COU...
    Formulas playlist: • Excel Advanced Formula...
    ➡️ Join this channel to get access to perks: / @leilagharani
    👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
    🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
    🎥 RESOURCES I recommend: www.xelplus.com/resources/
    🚩Let’s connect on social:
    Instagram: / lgharani
    LinkedIn: / xelplus
    Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
    #Excel

Комментарии • 707

  • @LeilaGharani
    @LeilaGharani  5 месяцев назад +1

    Grab the file I used in the video from here 👉 pages.xelplus.com/sum-between-dates-file

  • @user-jv1cl2fs6m
    @user-jv1cl2fs6m Год назад +2

    I CANT EVEN THANK YOU ENOUGH!! I had been struggling since March 2017 (and searching countless Excel videos) and asking several Excel experts, and nobody could start to help.. and finally I found this video! It not only fixed my issue and saved me hours of time each year, BUT when I go to save 2022's workbook as 2023, all I'll need to do is change 2 digits and the ENTIRE 2023 workbook will update!! Thank you from the bottom of my heart! ❤️ MUAH!!

    • @LeilaGharani
      @LeilaGharani  Год назад

      That's great to hear! Glad it was helpful.

  • @ajwatypingphotocopying8971
    @ajwatypingphotocopying8971 4 года назад +3

    I MANUALLY FINISHED MY PREVIOUS TASK BUT THEN IN NEXT TRY AND TASK I OVER CAME MY DIFFICULTY. THANK YOU GORGEOUS LADY, SO MUCH LOVE

  • @oliverbuckley5121
    @oliverbuckley5121 5 лет назад +7

    SUMIFS is a great function, but I never realised you could use > and

  • @fessyanalyst
    @fessyanalyst Год назад +2

    I needed this to complete a particular task. You're good. I love the way you simplify and show possible errors as you work.

  • @kileesmommy
    @kileesmommy 3 месяца назад +1

    You are amazing! I watched a couple of your videos and was able to solve a problem I was having doing a formula. I had been watching other videos and trying to figure it out for a week! You're the best!!!

  • @tomgreening9875
    @tomgreening9875 4 года назад

    Leila, I find your videos the clearest, easiest to follow explanations of Excel, and have recommended them to people I work with.
    Please consider doing a video explaining the conventions for specifying text wildcards, partial matches, exact matches, and inequality conditions, for common functions like COUNTIFS, SUMIFS, MATCH, AGGREGATE, and ADVANCED FILTER's criteria. How to do it with the criterion inside the function argument, and how to do it if the criterion is in referenced cells. They seem to differ, especially for partial matches of text. For instance, when I specify ADVANCED FILTER condition as a text string like xyz (without any surrounding quotes or *) it matched any string that started with xyz. A general explanation the conventions would help a lot.

  • @kuuuyajim
    @kuuuyajim 5 лет назад +5

    Thank you very much for this! I've been trying to learn how to sum up values based on dates and now I was able to figure it out with your help. Thank you very much for this Leila! 😉

  • @rizalfatoni4075
    @rizalfatoni4075 2 года назад +1

    Sumifs from date A to date B is really useful for tracking data progress. Thanks a lot Leila.

  • @federicococchis2679
    @federicococchis2679 8 месяцев назад +1

    very helpfull, Thank you very much for this clear explanation. My will to live has increased dramatically after solving the problem that was passed down in my generation for years. Thank you again

  • @TraderCOP
    @TraderCOP Год назад +1

    4 years later, this video is still valuable.

  • @franciscoveras7405
    @franciscoveras7405 6 лет назад

    Nothing more exciting than when you have been working for an entire day trying to figurate out how to sum values between two dates and just when you decide to commence to work with a VBA code, you see a video from Leila with the very exact thing that you are looking. THANKS, LEILA!!!!! you save me again

    • @LeilaGharani
      @LeilaGharani  6 лет назад

      Telepathy is real! I'm very glad you didn't have to use VBA here :)

  • @sharknado523
    @sharknado523 4 года назад +3

    This was such a helpful video, you have a unique talent of breaking these things down! Getting sums on the month from data sets using different days is always such a mind-bender, I'm definitely adding this to my favorites because I know I'll get stuck again.

  • @rickyroko1
    @rickyroko1 5 лет назад

    I had been struggling for 1 hours to do this, trying to read blogs and sloppy guides, before i found this. You were brillant! Now IT IS easy!

  • @DT-vc7hd
    @DT-vc7hd 2 года назад

    Thank you! I failed several times on my own to create a function with multiple criteria (Date Start, Date End, Category), and this tutorial gave me knowledge to accomplish that!

  • @williandepaulagomes4557
    @williandepaulagomes4557 5 лет назад

    Leila é a melhor instrutora de excel do mundo! Obrigadooo!!
    Leila is better excel's teacher all over the world! Thanks for you teaching! 😍👏🏾👏🏾👏🏾

  • @gokuls9557
    @gokuls9557 4 года назад

    You're simply amazing. I usually watch all of your videos to learn formula and macros.

  • @OmarFeliciano
    @OmarFeliciano 5 лет назад

    I cannot get enough of Excel formulas and Functions, honestly I'm obsessed to the point that I create whatever it's needed to have an excuse to work with Excel. Same when I'm debugging software to reverse engineer it. It calms me down and relaxes. That and the way you explain/show/teach its just the icing on the cake..

    • @LeilaGharani
      @LeilaGharani  5 лет назад +1

      Oh good, so I'm not alone :) Glad you like the videos!

  • @solquesttherapypllc6377
    @solquesttherapypllc6377 Год назад

    Thank you so much for this! I had been looking for something like this and couldn't seem to find it. You explained it clearly and I was able to make my 2023 Balance Sheet with categories and look at overall totals as well as monthly totals. I appreciate your wisdom, thank you for sharing it.

  • @craigfrisbeedogs4299
    @craigfrisbeedogs4299 Год назад

    Wow, you go super fast but I was able to learn the EOM function and added this to my sumifs to sum our families expenses by month. Thank you for posting this and taking my excel knowledge to the next level! I had to screen shot your formula and then blow it up so I could read it, but when I applied it to my data it worked the first time. That rarely happens:) Basic example I used to understand it: =SUMIFS(C:C,A:A,">="&E3,A:A,"

  • @ibrahimwork8692
    @ibrahimwork8692 4 года назад

    YOUR SUCH A LIFE SAVER. The best EXCEL tutor out there on youtube and the way you explain and demonstrate is so amazing. SIMPLE, RELEVANT AND ALWAYS TO THE POINT. A 1000 likes for all the great content and the efforts you make.

  • @shabirvadalia148
    @shabirvadalia148 2 года назад

    This function is phenomenal, an instrument that has enabled me to become efficient and effective. Well done.

  • @ziggymasternak586
    @ziggymasternak586 4 года назад

    I spent two days browsing through excel support sites, forums, LinkedIn training and even Excel inbuilt "help with this function" link which is actually a paid service and not necessarily will do what you want (you can't open the file until you pay :) ), until I came across your video and you made everything clear, resolved my worksheet problem and I have learned a lot at the same time. Thank you.

  • @wajidnawaz6014
    @wajidnawaz6014 3 года назад +8

    Leila, this tutorial has helped me complete a very time consuming task. great to once again learn from your experience - all the best :)

    • @LeilaGharani
      @LeilaGharani  3 года назад +2

      Wonderful! I'm glad it was helpful.

  • @jacquesconradie9941
    @jacquesconradie9941 10 месяцев назад

    Dear ms. Leila, we appreciate your clear logical explanations and your sweet friendly manner.

  • @martinmamone7553
    @martinmamone7553 3 года назад

    After googling for a formula that didn't work, I decided to try you tube. Your video worked like a charm. Excellent job, clear, concise and most importantly, it worked. Kudos

  • @GodWillIncreaseNitzborn
    @GodWillIncreaseNitzborn 4 года назад

    This formula to sumif between dates helped me big time to create countifs formula... 😍👌👍🏽 Praise be to God!

  • @remaxpinnacle3240
    @remaxpinnacle3240 2 года назад

    Thank you for explaining these things so clearly and concisely!

  • @ameshshamike8906
    @ameshshamike8906 2 месяца назад

    I find your learning process interesting. The content is highly valuable. Your videos are very helpful to me. Thank you.

  • @sachinrv1
    @sachinrv1 6 лет назад +1

    Hi Leila. Very nice video. You know; many times when I am working on reasonably huge data base for MIS, I prefer these fantastic SUMIFS, COUNTIFS and AVERAGEIFS functions, instead of doing pivot table or SUMPRODUCT. These functions are so useful and user need not have to do anything once they are in place. One could also use wild cards here to add to the beauty. Thanks for upload. u are so pretty teacher :)

  • @stephanieasante6111
    @stephanieasante6111 5 лет назад +1

    This is beautiful. Best excel tutorial I've seen by far. And it gave me exactly and beyond what I'm looking. Great Job!

    • @LeilaGharani
      @LeilaGharani  5 лет назад

      I'm very happy to hear that Stephanie! Glad it's useful.

  • @irviantantohaditomo8917
    @irviantantohaditomo8917 5 лет назад +1

    Awesome, Leila. I can improve my skills in ms excel. Thank you very much. God bless you.

  • @asimali5820
    @asimali5820 5 лет назад +2

    You are simply the GREATEST!

  • @asthegooseflies9019
    @asthegooseflies9019 4 года назад +1

    Terrific video - many thanks. Solved a lot of frustration! It is great that you show common mistakes with the formula build, to help struggling Excel users like me!

  • @jeromeastier462
    @jeromeastier462 4 года назад

    Excellent, you have a true pedagogic talent. Thank you!

  • @natalie6251
    @natalie6251 4 года назад

    Your tutorials are so helpful! Thank you so much!

  • @ravichandrankannappan6552
    @ravichandrankannappan6552 6 лет назад

    Hi Leila, Watching your Excel is always exciting as you not only explain the topics with examples but ,along the way, you show us so many little tricks and tips that keeps us updated with Excel skills. Thanks for your help!

    • @LeilaGharani
      @LeilaGharani  6 лет назад

      Thank you Ravi for your kind comment! I'm glad you find other helpful tips in the video :)

    • @ravichandrankannappan6552
      @ravichandrankannappan6552 6 лет назад

      Hi Leila, Is it possible to reference cell addresses for maximum and minimum Bounds under Format Axis section of Chart?. Of course , without using VBA codes.

  • @karenmarites5735
    @karenmarites5735 3 года назад

    During my off from work, I binge watch your videos. Keep safe, Leila!

  • @indus4494
    @indus4494 5 лет назад +2

    Thank u so much really it helped me to prepare a report I tried many formulas but I got this correctly

  • @joaocarneiro6683
    @joaocarneiro6683 4 года назад

    THank you for your videos. Learning a lot. Well explained and to the point. She is both a MVP and a MBP

  • @patinespeludos
    @patinespeludos 2 года назад

    thank you, you saved my life at work!

  • @nairobi203
    @nairobi203 Год назад

    1) This was exactly what I was looking for 2) This is by far the best and clearest video on this subject 3) You are simply the best...

  • @nsanch0181
    @nsanch0181 4 года назад

    Thank you for the review on summing dates. Your videos have been so helpful.

  • @yaashjut76
    @yaashjut76 6 лет назад +1

    Wonderful tool for calculations on calendar. Thank you Leila

  • @dickyrock1
    @dickyrock1 4 года назад +8

    Thanks so much, I just did this and felt like an absolute genius when the thing auto-filled and gave correct answers. Great videos keep them going.

    • @LeilaGharani
      @LeilaGharani  4 года назад +4

      My pleasure. Glad it's helpful.

  • @behdadmalakan9686
    @behdadmalakan9686 4 года назад

    Thank you Leila, your videos are so helpful. Keep up the good work, much appreciated!

  • @craigcanter9223
    @craigcanter9223 4 года назад +1

    Thank you. This saved me an hour plus it is a much more efficient solution than my alternative

  • @EmpresaHotelAccts
    @EmpresaHotelAccts 4 месяца назад

    Thank you Leila!!! You've saved a life here

  • @radsan3006
    @radsan3006 5 лет назад +1

    That was such a huge help, thank you so much Leila!

  • @sheeshman9713
    @sheeshman9713 Год назад

    I am currently working on a project that I had to averageifs the selling price between 2 dates. this video saved my ass thank you so much

  • @ahmedmetiaz9673
    @ahmedmetiaz9673 4 года назад

    Thank you so much , for calculating monthly sales I use =TEXT([@Date];"mmmm") in another column and use the result as a criteria of sum if , I find it better

  • @GullBadani
    @GullBadani Год назад

    I love you for this video. i have been searching for this solution for 1 hour and then youtube recomend your videos then did it in one minute. Thank you so much.

  • @kimberlybatangdejarlo4675
    @kimberlybatangdejarlo4675 Год назад

    you save my life! thank you for your videos, as a newly promoted team leader your video really helps me..

  • @mktthatsme2009
    @mktthatsme2009 5 лет назад

    Thank you! Our stats tool broke and this helped me sum up all the raw data in minutes! You saved me so much time!

    • @LeilaGharani
      @LeilaGharani  5 лет назад

      You're most welcome Marcia. I'm glad the tutorial was helpful.

  • @eduardocastillo6663
    @eduardocastillo6663 3 года назад

    You just made my life a whole lot easier. Loved the video. Thank you!!!

  • @johnnyz7752
    @johnnyz7752 3 года назад +2

    Hi Leila, I LOVE watching your videos. I have learned a lot because of your help. Thank you !
    Quick question. In your 2nd example, is there a way to make the formula dynamic, for an on growing table?

  • @garys2187
    @garys2187 4 года назад

    Thank you so much. Very well explained. Including the part about where to put the quotes in the formula and the need to add the &. I struggled with why my formula wasn't working and then I found your video!!

  • @gabrieltavares8621
    @gabrieltavares8621 21 день назад

    THANK YOU SO MUCH THIS WAS SO USEFUL I LOVE YOU

  • @excelisfun
    @excelisfun 6 лет назад +12

    Great video, Teammate!!! : )

    • @LeilaGharani
      @LeilaGharani  6 лет назад +2

      Thank you Teammate Mike :)

    • @mentalcase9388
      @mentalcase9388 5 лет назад

      Very Thanks Great, But I want this formula run in Excel 2003, How this formula run in Excel 2003 ?

    • @raymeester7883
      @raymeester7883 5 лет назад

      Your team has made so many people's lives easier and happier.

    • @davidalejandrogutierrezgra7376
      @davidalejandrogutierrezgra7376 5 лет назад

      Wow, love to see that @ExcellsFun and @Leila Gharani support each other. You both guys are my excel rock starts! :) thanks a lot! :)

  • @josiahpitman
    @josiahpitman 4 года назад +1

    Thank you, exactly what I was looking for!!!

  • @andrewschroeder5485
    @andrewschroeder5485 4 года назад

    This is gonna make it so much easier to make a nice excel budget, thanks!

  • @user-ru2cb6kw7b
    @user-ru2cb6kw7b 2 месяца назад

    You just gave me what I needed, been trying to figure how to use the criteria

  • @apersonyoudontknow3346
    @apersonyoudontknow3346 Год назад

    Thank you helped me with my cis 200 Professor homework a real goat

  • @lkumar2727
    @lkumar2727 5 лет назад +1

    You are amazing leila.... Your teaching style and content so amazing ... I am fan of you.

  • @LILIANVISCONTI
    @LILIANVISCONTI 4 года назад

    Thank you so much. The way you talk and explain things makes everything so easy to me.

  • @ashutoshshete4942
    @ashutoshshete4942 2 года назад

    Your videos are so great! Always. Thank you so much. God bless you!

  • @user-py5tc5bw1s
    @user-py5tc5bw1s Год назад

    The excel from you is never die 👍 Now is useful to my works Thanks 🙏 ❤.

  • @pakheimpharma2807
    @pakheimpharma2807 Месяц назад

    this was so helpful thanks

  • @maheshyadav7455
    @maheshyadav7455 6 лет назад

    Your all excel video is very helpful, Thanku so much

  • @hevkev1
    @hevkev1 3 месяца назад

    This was fantastic! Thank you.

  • @chimarokenwaji
    @chimarokenwaji 2 года назад

    Thank you so much for this lecture. You just solved a little problem for me. I appreciate.

  • @reyadhalbarakat2466
    @reyadhalbarakat2466 4 года назад

    Dear Leila, Thank you very much for the great video and simple explanation.

  • @09shirish
    @09shirish 5 лет назад

    Best formula information ! Thanks a lot !!!

  • @edgeui
    @edgeui 5 лет назад

    Thank you so much! Great tutorial.

  • @adnanabbasi3832
    @adnanabbasi3832 4 года назад

    Hi, Leila i've been watching you videos on excel tips & trick and found most of them absolutely useful and worth follow.
    Now, i have a situation in excel where i have to identify sales quantity of a material from it respective material ageing. It is important to mention that Material Ageing is based on data prior to start of sales we are monitoring.
    Example
    Below is the status of 31Dec2019:
    Material1
    age slab1 (0-180 days) = qty 100
    age slab2 (181-365 days) = qty 3100
    age slab 3 (>365 days) = qty 350
    Sales from Jan-Mar is qty 575
    Now i want the result like this:
    MATERIAL1 = AGE SLAB3 SOLD QTY 350
    AGE SLAB2 SOLD QTY 225
    If you want i will share the format with you in excel.
    Thank you
    adnan

  • @ShikaLH
    @ShikaLH 5 лет назад

    Thank you. Awesome explanation.

  • @sam71839
    @sam71839 4 года назад

    thank you so much whenever I have any doubt in excel your video helps me out from trouble. keep on. God bless

  • @gurmeetsingh-cq6br
    @gurmeetsingh-cq6br 4 года назад

    your every lesson excites me to learn more and more.Great teaching method.

  • @GB-tr1tu
    @GB-tr1tu 4 года назад

    Wow !! Such a clear explanation. Was so easy to understand. Thanks and keep up the good work.

  • @niksm8080
    @niksm8080 5 лет назад +1

    saving my butt as usual! thanks for all the great tutorials!

  • @ColinSemple
    @ColinSemple Год назад

    Time Saving!!! So easy to follow, and will be helpful for years. Thanks for the great video.

  • @abuumar9491
    @abuumar9491 11 месяцев назад

    Thank you for such easy explanation , absolutely 100% educational.

  • @tarifadib
    @tarifadib 2 года назад

    thank you so much for this wonderful tutorial and free workbook

  • @widuroadi
    @widuroadi 5 месяцев назад

    Thank You So Much...Very Helpfull....God Bless You

  • @micro_mechanologist
    @micro_mechanologist 4 года назад +1

    Great!! Exactly what I needed and perfectly explained.

  • @ivanczar9413
    @ivanczar9413 Год назад

    Thank you!
    I was looking for exactly this!

  • @fonkweasong161
    @fonkweasong161 2 года назад

    You are a blesing to this world. Thanks a lot for your videos.

  • @usamahashmi5453
    @usamahashmi5453 Месяц назад

    Wonderful video.. it's helped a lot ..

  • @Start2o21
    @Start2o21 5 лет назад

    Superb... I was looking for that video.... Thank you so much yours all videos on Excel are too much useful.
    Thank youuuuu soooo muchhhhhhhh

  • @boucharebyasmine9908
    @boucharebyasmine9908 5 лет назад

    Thanks a lot for these videos..really a good channel and tutor

  • @antoniobacic5674
    @antoniobacic5674 2 года назад

    exemplary, clear & concise - thank you!

  • @Dev_Bartwal
    @Dev_Bartwal 6 лет назад +2

    Thank you LG💕 very classy class Thanks a lot

    • @LeilaGharani
      @LeilaGharani  6 лет назад

      You're welcome Dev :) Thank you for your continuous support.

  • @alejandromarquez5565
    @alejandromarquez5565 10 месяцев назад

    Thanks a lot for sharing , it is a lot of time savings watching your videos , it is better and easier to learn from your videos than reading excel’s help! Great Job !!

  • @syahadatrosli3852
    @syahadatrosli3852 4 года назад

    Thank you for sharing. This knowledge help me alot.

  • @rina2012ful
    @rina2012ful 2 года назад

    You have made it easy for me, thanks!

  • @janeannzamora5216
    @janeannzamora5216 3 месяца назад

    Thank you huge help

  • @MalinaC
    @MalinaC 5 лет назад +2

    Thanks for the video, Leila!

  • @shreemanurkar895
    @shreemanurkar895 3 года назад

    Excellent Information and presentation! Thank you so much.

  • @sikandaralishah9767
    @sikandaralishah9767 2 года назад

    Thank you so much respected teacher !

  • @jameson-s
    @jameson-s 3 года назад +1

    Taght me a cool trick with this one. I was looking for a video that could use an input year to determine an allowance on tax for that year then totaling up to give an allowance from typing in yes. I thought it would totally fail but it worked perfectly. That would have taken me a week to learn. I just improvised on what you video said. WORKS PERFECT. thank you for this video. Subscribed and thumbs up. Who said they can't teach an old dog new tricks. they are so wrong.