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
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.

Comments

  • that
    that Posts: 1,532 Forumite
    edited 29 September 2018 at 9:06PM
    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'
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

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

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.