Look Who it Was Random video

Excel - Adding Subtotals by Month When Your Data is Showing Daily Dates - Episode 568

1,553 views · Published 6 July 2009 · 1:46 · Indexed 2 October 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Adding Subtotals by Month When Your Data is Showing Daily Dates
Welcome back to the MrExcel netcast! In today's episode, we have a question from Murray about adding monthly subtotals in Excel. If you have a question for the netcast, don't hesitate to reach out to us via phone, voicemail, or email.

Murray's data has dates going down the left-hand side and various amounts. She wants to add subtotals at every change in month, but the usual method of using Data, Subtotals, and selecting "At each change in, Date" doesn't give the desired result. My solution to this is to format the dates in column A to display only the month. This can be done by selecting the column, going to Format Cells, and choosing the desired date format.

Once the dates are formatted, you can add the subtotals by using Data, Subtotals, and selecting "At each change in, Date." Excel will then add in the monthly subtotals. After that, you can go back and change the date format in column A to its original form. This may seem like a bit of a hassle, but it's definitely easier than adding a new column to calculate the month.

Thank you, Murray, for your great question. If you have a question for the podcast, don't hesitate to reach out to us. We'll do our best to answer it in a future episode. Thanks for tuning in to this netcast from MrExcel. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Introduction and question from Murray 
(00:26) Issue with adding subtotals at each change in month 
(00:42) Solution: format dates as months 
(00:53) Adding subtotals using Data, Subtotals 
(01:03) Changing dates back to regular format 
(01:14) Easier solution than adding a new column 
(01:24) Conclusion and invitation for future questions 
(01:34) Clicking Like really helps the algorithm

#excel #microsoft  #tutorial 

This video answers these common search terms:
Efficient method for adding subtotals at each change in month in Excel
Excel data analysis: adding subtotals by month
Excel tips for calculating subtotals by month
Formatting cells to display month in Excel
How to add subtotals at each change in month in Excel
MrExcel netcast: How to add subtotals by month
Shortcut for adding subtotals in Excel
Simplifying subtotal calculations in Excel using formatting
Solving subtotal issue in Excel: getting subtotals for each month
Step-by-step guide to adding monthly subtotals in Excel
Using Data  Subtotals feature in Excel
YouTube tutorial on adding subtotals in Excel

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152507/



If you have a column of daily dates, how can you subtotal by month? Episode 568 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

More from this channel