Excel Formula Help

NathanMorganNathanMorgan Forumite
172 Posts
Sixth Anniversary 100 Posts
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.


  • edited 29 September 2018 at 8:06PM
    thatthat Forumite
    1.5K Posts
    edited 29 September 2018 at 8: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.
Latest MSE News and Guides

Boost your Nectar points

Get up to £25 in bonus points

MSE News

Ask an Expert: Scams

Watch MSE Katie's answers to your questions

MSE Forum

Hot Diamonds 40% off code

Including already-reduced outlet stock

MSE Deals