Hi,
I have a problem solving this task. Please help!
I hope I was able to upload an excel file to see what is not clear to me
Create a summary of sales forecast for years 1-5, using the data below
Hi,
I have a problem solving this task. Please help!
I hope I was able to upload an excel file to see what is not clear to me
Create a summary of sales forecast for years 1-5, using the data below
You don't say how much detail you need and what you mean by a Sales Forecast.
Here's one formula that will sum the total all 5 years for the 12 month total in column N
Add a new sheet copy the row labels and in B3 enter
=SUM('Year 1:Year 5'!N3)
Copy down for the totals of other rows.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
The text itself says what I wrote and that is why nothing is clear to me and I cannot solve the problem. Nothing is clear to me. If you can do this task and explain to me what you did. Thanks in advance.
Last edited by danluk12; 05-09-2021 at 10:10 AM.
Thanks, I did it.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
As you are new I will add it for you
https://www.msofficeforums.com/excel...st-please.html
https://chandoo.org/forum/threads/i-...se-help.46239/
OK. Thanks. I really didn't read the rules. I'll follow the rules next time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks