good sir/maam,
Please help me make sub-total by year and by month. kindly open the attach file for reference.
thank you and God bless
Hi Elinor Ignacio,
This is typical something for a Pivot Table. So I made a start for you to show you how that can work out. See attached file, tab 'PivotTable'. Maybe you want to learn more about PivotTables: check this website!
Frans
Hello Elinor,
The solution given by Frans is better than the one I am to provide here, but I give you my reply just so you can see how this can be solved in different ways. There are of course other solutions that can be used too.
My approach here is to create one worksheet per month, not having all data in one table or range as in the example you provided. Reason to that is to visually make it more easier to view it all. The downside is that this approach usually also means more work if you want to create dynamic charts and such.
In the attached file you see two worksheets, the first one I have used a range as a list, the second I have used a table as a list. The formula is the same, apart that with a table you get the option to add a total row at the bottom of table. Check out the sample file and try out for yourself.
Happy Holiday's!
Br,
Anders Sehlstedt
Good day!
thank you very much for your replies.
