Forum Discussion
Solved
Subtotals in a table
Hello friends. I have a workbook with one page for each account; like groceries, rent etc. The data is already sorted on transaction date; like 1/14/2021 I want to present the data with a break wi...
Hello Hans.
I understand that. I believe I had converted it; but I will double check.
Thanks,
FastEddyG2
The subject of your question says "Subtotals in a table".
If your data are in a table (created by selecting Insert > Table), you cannot insert subtotals. Tables don't allow that. So you'd have to convert the table to a normal range. You should then be able to create subtotals.
Hello Hans.
I understand that. I believe I had converted it; but I will double check.
Thanks,
FastEddyG2
- Hello Hans.
Thank you for your help. I checked and I did not properly convert it. I corrected that and now it works as it should.
Thanks again! Hi Hans.
You got it! I had not properly converted Excel page to Table. It works now!
Thanks for your guidance.
Best regards,
FastEddyG2