![]() To subtotal by month and year following these simple steps: This will remove all table functionality from the data except the table formatting. To convert your data, from the Table Tools > Design menu, select Tools > Convert to Range. If your data is in a table format, you will first need to convert the table to a normal range of data before following the below steps. You are welcome to download the workbook to practice.Īpplies To: Microsoft ® Excel ® for Windows 2010, 2013, and 2016. However, when using the Subtotal command, the desired result is not being achieved as it creates a subtotal for each day. ![]() ![]() If your data has a column of dates, you may want to subtotal dates by month and year. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |