Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
52
Views
Topic starter
Hi,
I have a problem solving this task. Please help!
Nothing is clear to me. If anyone can do this task and explain to me what you did. Thanks, advance!
Create a summary of sales forecast for years 1-5, using the data below
Posted : 10/05/2021 9:46 am
Hi Danijela,
Welcome to our forum!
Looking at the file, they currently have a detailed forecast by account over 12 months x 5 years and I guess they want to see a summary sheet that shows the total per year by account. i.e. one sheet with accounts in column A and years 1 - 5 in columns B:F with a total column in G.
You could use Power Query to consolidate the sheets of data, but you need to be careful because the accounts are not the same in each sheet.
Hope that helps.
Mynda
Posted : 11/05/2021 1:19 am
Topic starter
Thanks.
Posted : 12/05/2021 9:26 am
