Excel Formula Help

172 Posts

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
This discussion has been closed.
Latest MSE News and Guides
Replies
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'