Thank you so very much for this tutorial! I have been trying to find out how to do this formula for a long time and you have explained it very simply, step by step, so I was able to put in the correct formula, and it works! So pleased!!! Thank you!!! :-)
Thanks very much for this! I had a table of expenses by week that I needed to easily total by month to create data for a table. Exactly what I was looking for!
Short and to the point. What if I have date & time in two different columns and want to add between a two different date-time combinations...what would that formula look like?
Wow!! It's so simple once you explain it. I tried the same formula except for the quotes and ampersand. In other words, I was nowhere near the correct formula. Thank you so much for your expertise. :)
Very helpful and easy follow video! Is there a version of it that would look up 2 criteria? i.e. look of values within a date range for a specific product type
A note to others. I kept receiving a zero from this formula. Turns out that my dates were in text format. I used Data>Text to columns to force them to become dates, and everything worked after that. I hope that helps someone.
Amazing video! Thank you.. :) I struggled a little bit getting it to work, but found out it was due to the fact that my date cells were merged - after that it worked like a charm.. :)
This is fantastic... can you tell me how to make this formula for show error if sum range is empty. because this formula suppose blank cell as 0. i want error showing message on blank cell @contextures inc
Hello! I loved your tutorial, it's very helpful. To be honest, this is the closest solution to my problem now. But I have a question and I'm hoping you have an answer. For example, I have separated the Due Dates by conditionally highlighting them between, less than 30 days, between 30-60 days and 61 days above, is there a formula where the total amounts can be totaled? For example, I need the total amount to be paid of vendors who's Due Date passed less than 30 days? My boss wanted me to have this and your kind response will he highly appreciated. I hope you can help me. Thank you 🙏🏻
Thanks, John, and you could use 3 COUNTIFS formulas for that. Check for invoices with no Paid date, then check if the Due date is in one of your date ranges. For example: =COUNTIFS(Paid,"",Due,">="&TODAY()-29,Due,"="&TODAY()-60,Due,"
Ahh hah, very cool. I've been trying to get this done for about a week now with no success! Your vid is intuative and easy to follow.Worked like a charm, well Done and thx again...
Excellent , sir, u have done excellent job i appreciate n expected more from yr side to teach us that v can learn more n more ....... thnx, yr version is old of 2013 , pls describe latest version of 2018
what if you have multiple rows of data relating to each sepcific date in a list, i.e. units sold, cost of goods sold, interest pmts and so on and you want to copy the formula over? Does the dates have to be right next to the column (or row) you want to sum up? great video btw and thanks for any answer!
Hi, may I know how to count the selected cells within the period covered. Sample: I only select (E190, E205, E212 within May 4 to 10, 2021 only) thanks
What about in the event the event where the date range cells are empty? Is there a way to pull the full sum if no dates are provided (instead of getting a null value)?
This formula is too helps me. More over can you tell how to get sum in category wise. Example. In this table add category a,b,c like. Need total sum of a=? , B=? , C=? Like. Can you help me. Because I want to make a my own food budget table
@Elisabeth, what do you see in the status bar, if you select the cells that have the values you want to sum? Do you see a sum in the status bar, or just a count?
hi thank you great formula. if i want to write down the date in the formula instead of choosing on other cell, what the magic word after "&" ? thank you
Thank you so much for this video it helped tremendously with one problem I was having. I was able to apply your SUMIF formula to 3 that I needed (MINIF, MAXIF & AVERAGEIF). My question is how can I get the standard deviation of those specific Min, Max & Average numbers? Example of my formula: =averageifs(A4:A89,D4:D89,">=" & B2,D4:D89,"
How can I do this but instead of a date range just have a cell sum the numbers according to whole month? So I won't need to write a date range it will just sum up if its Jan or Feb etc? Thanks E
This make easy for my work. just 1 question this formula can apply with raw data in horinzontal condition? Because as you show. Your raw data in vertical condition
Hi I'm trying to set up this work sheet that keeps record of what gets done daily at work , Im suing formula sumifs , but there's only one thing when I change the date it erases what was recorded the day before is there a way where it won't erase what was done the day before?
Instead of having just 2 cells, where you enter the start and end date, enter new dates each day, below the previous dates. Put each day's SUMIFS formula in the next column, and copy the formula down each day.
Nice video! Come in handy. I have a question. Could I input the empty cells (in which cells data will be input in future) in both of criteria range (maybe it will long till last row of excel) for automatic calculation? And also could I define start & end as same for each day calculation method? Thank u.
This is amazing, What would be perfect if this could be I cooperated in to a pivot table, so the table returns a sum of the values i.e. products sold(£) during one particular date range. Any idea Debra?
Some how , how I ll know that on this article the formula have to apply, or how v can use the different formula that ll be prefect... n works properly.....
I need some help I have calculated the sum of each month everything works fine until it gets to December. it does put any data on the particular month unless I put another month such as January please help.
video from 11 years ago saved my job, thank you!
You're welcome, Dimas, and thanks for letting me know that this video helped you!
@@contextures I love the fact that you even replied to my comment 🥲, wish you the best for anything you do! ❤
I don't even have the words for how awesome your channel is. Thank you so much. You make me seem like an EXCEL guru.
Thank you!
thanks alot mam ,finally got it ,searching this for a long time😍
You're welcome Sahad, and thanks for letting me know the video had what you were looking for!
Thank you so much for the helpful information
You're welcome, Talal, and thanks for your comment!
You save my 1 hours thank you so much
You're welcome, and I'm glad the video helped save your time!
-Debra
Oh gosh. at last. No word could describe my gratitude. Thanks loads.
You just made something I am working on so much easier.
Thanks, Ugo, and that's great to hear!
Thank you so very much for this tutorial! I have been trying to find out how to do this formula for a long time and you have explained it very simply, step by step, so I was able to put in the correct formula, and it works! So pleased!!! Thank you!!! :-)
You're welcome, Janet, and thanks for your lovely comment - I appreciate it!
Thanks very much for this! I had a table of expenses by week that I needed to easily total by month to create data for a table. Exactly what I was looking for!
Very useful even after 8 years. Thanks!
You're welcome, Poojitha, and thanks for letting me know that the video was useful to you, after so many years!
@@contextures Glad that you saw my response. 😊
Thanks A lot for saving my time
You're welcome, Pradeep, and thanks for your comment!
It's really helps, Thanks from AUG 2021... 🙏🙂
You're welcome, Kaushal, and thanks for your comment!
you saved me lot of time...... after so many hit and trials
thanks a lot
Truly brilliant! I had been using filters before, which is very clunky. The presentation was excellent also, easy to follow and understand!
Thanks, Andrew! I'm glad you liked the video.
Your clarity is amazing.Talented teacher welldone!
Thank you very much!
Great video. Simple and to the point. Worked perfectly! Thanks
very neat explanation.....
Thank you, Mohammed!
Very short and precise ,exactly what I was looking for ,Thanks
Thanks! I'm glad it helped you
Thank you so much!
You're welcome, and thanks for your comment!
Wow Thank you for the video.
Very helpful video
Thank u
3 hours of failing, and then you save me in less than 3 minutes. Thank you!
All of your videos are of great help - can't thank you enough.
Thank you! I'm glad you find the videos helpful
Short and to the point. What if I have date & time in two different columns and want to add between a two different date-time combinations...what would that formula look like?
Just what I needed (works well with COUNTIFS, too). Thank you very much.
You're welcome, Frank! Thanks for your comment
This was the best! I got the info I needed within the first 5 minutes. Many thanks!
You're welcome, Mark! Thank you for letting me know that it helped
Tq soo much mam, this helped me alot
You're welcome, Sonia, and thanks for your comment!
Nice. You kept it easy!!!. Thank You.
Thank you!
Wow!! It's so simple once you explain it. I tried the same formula except for the quotes and ampersand. In other words, I was nowhere near the correct formula. Thank you so much for your expertise. :)
You're welcome, Ellen, and thanks for letting me know that the video helped you!
Very helpful and easy follow video! Is there a version of it that would look up 2 criteria? i.e. look of values within a date range for a specific product type
Thanks Emily, and we did another SUMIFS video recently, with text criteria. Maybe it will help you. ruclips.net/video/hHHKElZsLAU/видео.html
Thanks really helpful
I've been loosing my mind trying to find out how to solve this, and in a way I can understand - Thank you!
Thanks very useful.
A note to others. I kept receiving a zero from this formula. Turns out that my dates were in text format. I used Data>Text to columns to force them to become dates, and everything worked after that. I hope that helps someone.
Super helpful and exactly what I needed!
i was searching for it
thank you so much
Thank you
You're welcome, and thanks for your comment!
Amazing video! Thank you.. :) I struggled a little bit getting it to work, but found out it was due to the fact that my date cells were merged - after that it worked like a charm.. :)
You''re welcome! Thanks for letting me know how you fixed the formula when it wasn't working.
This is fantastic... can you tell me how to make this formula for show error if sum range is empty. because this formula suppose blank cell as 0. i want error showing message on blank cell
@contextures inc
Thank you so much! Been looking for this. I already subscribed as my way of thanking you. 😊
Super helpful, thank you!!
Hello! I loved your tutorial, it's very helpful. To be honest, this is the closest solution to my problem now. But I have a question and I'm hoping you have an answer. For example, I have separated the Due Dates by conditionally highlighting them between, less than 30 days, between 30-60 days and 61 days above, is there a formula where the total amounts can be totaled?
For example, I need the total amount to be paid of vendors who's Due Date passed less than 30 days?
My boss wanted me to have this and your kind response will he highly appreciated. I hope you can help me. Thank you 🙏🏻
Thanks, John, and you could use 3 COUNTIFS formulas for that. Check for invoices with no Paid date, then check if the Due date is in one of your date ranges. For example:
=COUNTIFS(Paid,"",Due,">="&TODAY()-29,Due,"="&TODAY()-60,Due,"
Nice perfect, exactly what I was looking for.. Thanks
+Mark Nelson You're welcome! Thanks for letting me know that the video helped.
Ahh hah, very cool. I've been trying to get this done for about a week now with no success! Your vid is intuative and easy to follow.Worked like a charm, well Done and thx again...
Thank you, David! Glad the video helped you get your work done
How do I collect amount and dates from several sheets? I have 33 sheets, and need a week of sales tottal.
Thank you very much, just what I was looking for
Thank you SO much! this was one of the best tutorials.
This is a very helpful video. Super helpful.
Thank you very much :)
Thank you so much. This really helped alot.
THANK YOU SUPER
You're welcome, and thanks for your comment!
Excellent , sir, u have done excellent job i appreciate n expected more from yr side to teach us that v can learn more n more ....... thnx, yr version is old of 2013 , pls describe latest version of 2018
It would be the same in the latest version of Excel.
love ya! thx!
You're welcome, Ayan, and thanks for your comment!
what if you have multiple rows of data relating to each sepcific date in a list, i.e. units sold, cost of goods sold, interest pmts and so on and you want to copy the formula over? Does the dates have to be right next to the column (or row) you want to sum up? great video btw and thanks for any answer!
Perfect for a problem I had
Thank you. Works perfectly!
thankyou so much
Thanks a lot.
Excellent Video
Thank you, Charles!
Hi, may I know how to count the selected cells within the period covered. Sample: I only select (E190, E205, E212 within May 4 to 10, 2021 only) thanks
What about in the event the event where the date range cells are empty? Is there a way to pull the full sum if no dates are provided (instead of getting a null value)?
Extremely helpful! Thanks for such a wonderful tutorial :)
hey plz can u show me how to see the end of day sale total (daily sale) after every transaction is done should be saved at some column . tnxxxx
Thank You - this helped me lot
You're welcome, Sagar! Thank you for letting me know that the video helped
This formula is too helps me. More over can you tell how to get sum in category wise. Example. In this table add category a,b,c like. Need total sum of a=? , B=? , C=? Like. Can you help me. Because I want to make a my own food budget table
Thanks, I couldn't find that anywhere
You're welcome, and thanks for letting me know that it helped you
Very nice
if you share this excel sheet then it will be easier and faster to learn
Can you explain through same with sumofproduct formula
Hi just wondering if this formula works also if I want to get the sum in two colums.
@Elisabeth, what do you see in the status bar, if you select the cells that have the values you want to sum? Do you see a sum in the status bar, or just a count?
This Helped so much! Thank you for your video!
Thanks, Nice tutorial
You're welcome, Enamul, and thanks for your comment!
So helpful, regards
Thanks Debra
amazing!!!! love this share! Thanks!
Thanks, I'm glad you liked the video!
Perfect! Thank you very much!
hi thank you great formula. if i want to write down the date in the formula instead of choosing on other cell, what the magic word after "&" ? thank you
Thanks, and for a date, use DATEVALUE("3/1/17") or DATE(2017,8,1)
thnx
Nice trick.
What if my units were names? Using this same formula im getting back 0. All suggestions appreciated.
Thanks,
nice vedio ,thanks,
You're welcome, Carmel, and thanks for your comment!
hello is there away to sum one cell live data another word if live data is coming in one cell is there away to sum that data if so where and how
Thank you so much for this video it helped tremendously with one problem I was having. I was able to apply your SUMIF formula to 3 that I needed (MINIF, MAXIF & AVERAGEIF). My question is how can I get the standard deviation of those specific Min, Max & Average numbers?
Example of my formula:
=averageifs(A4:A89,D4:D89,">=" & B2,D4:D89,"
You could build a Standard Dev IF formula -- array entered with Ctrl+Shift+Enter
=STDEVP(IF(D4:D89>=B2,IF(D4:D89
How can I do this but instead of a date range just have a cell sum the numbers according to whole month? So I won't need to write a date range it will just sum up if its Jan or Feb etc? Thanks E
you are great ........................
Thank you, I love you!
+onebombcutie You're welcome!
+onebombcutie You're welcome!
Thank you very much
You're welcome, Sora! Thanks for your comment.
Hats off to you...
Thank you!
This make easy for my work. just 1 question this formula can apply with raw data in horinzontal condition?
Because as you show. Your raw data in vertical condition
What if I want the product of cells that fall within a date range?
Hi I'm trying to set up this work sheet that keeps record of what gets done daily at work , Im suing formula sumifs , but there's only one thing when I change the date it erases what was recorded the day before is there a way where it won't erase what was done the day before?
Instead of having just 2 cells, where you enter the start and end date, enter new dates each day, below the previous dates. Put each day's SUMIFS formula in the next column, and copy the formula down each day.
Nice video! Come in handy. I have a question. Could I input the empty cells (in which cells data will be input in future) in both of criteria range (maybe it will long till last row of excel) for automatic calculation?
And also could I define start & end as same for each day calculation method?
Thank u.
This is amazing, What would be perfect if this could be I cooperated in to a pivot table, so the table returns a sum of the values i.e. products sold(£) during one particular date range. Any idea Debra?
Only month criteria can we sum the table.... I am not able to solve.
Some how , how I ll know that on this article the formula have to apply, or how v can use the different formula that ll be prefect... n works properly.....
How to sum if dates in rowes landscape
is there a way to use purely function notation?
I need some help I have calculated the sum of each month everything works fine until it gets to December. it does put any data on the particular month unless I put another month such as January please help.
thankx u shared great
nice, but why we use &, if we do not use it it will not work? any clarification please.
"&" means that the next string of commands are part of the previous string. it is also used for concatenate function.