We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
We're aware that some users are experiencing technical issues which the team are working to resolve. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Excel Formula Help
Options

NathanMorgan
Posts: 173 Forumite

in Techie Stuff
I want to create a spreadsheet which just adds up monthly amounts with no particular dates inputted justs by months so each amount I input is inputted as September and an amount of say 100 but its a continuous spreadsheet for my data inputting and then each month on the top with the totals for those months (if that makes sense).
Any help will be great, thanks.
Any help will be great, thanks.
0
Comments
-
easy way, just to get you started. Format the data into three columns like
may-2018 tea 100
may-2018 milk 200
may-2018 bread 300
June-2018 tea 100
June-2018 milk 200
June-2018 bread 300
then use pivot table and group by the first column.
Would think to make the whole first column as a named range, or range, rather than select individual cell ranges.
youtube had loads of good pivot table explanations, but the basic function of a pivot table is to 'group by'0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 350.6K Banking & Borrowing
- 253K Reduce Debt & Boost Income
- 453.4K Spending & Discounts
- 243.6K Work, Benefits & Business
- 598.4K Mortgages, Homes & Bills
- 176.8K Life & Family
- 256.8K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards