How to create a summary worksheet in Excel with multiple sheets

[vic.moon1]

Hi there

I am not sure if I am allowed to post this thread (please let me know if I am not allowed), but I have to create a summary worksheet in Excel. It's about sales. For example, the original question states that I need to insert an appropriate formulas in total column for each book category linking to the September and December Quarters tables and producing the total book sales for each category. As an example, the Formula in Travel Books category totals column should produce &9,849 (Total Travel September QTR+Total Travel Dec Qtr).

Can someone explain how do it? I don't really understand how to create this summary, how usually it looks like and what kind of formula do I have to use. I am stuck here and can't get it working. Please, help!!!

P.S. I have attached an excel file so that it is easier to see what I mean.

Task 1.xls

Thank you in advance!

[JohnTopley]

You have a SUMMARY table which could also just be a QuarterSummary with September and December totals for each Category.

As a hint:

To reference data in one sheet from another:

If the following is in A3 of Sheet1

=Sheet4!A5 will place the data from A5 in Sheet4 in A3 of Sheet1.

[vic.moon1]

You have a SUMMARY table which could also just be a QuarterSummary with September and December totals for each Category.

As a hint:

To reference dat in one sheet from another:

If the following in A3 of Sheet1

=Sheet4!A5 will place the data from A5 in Sheet4 in A3 of Sheet1.

Hi

I've got the table going now and thank you for the hint but I still do not understand how to reference the data from Sheet 1 to Sheet 2 into Summary Table.
What kind of formula do I need to use?
Can I use SUM formula?....Thank you for the hint but I am still not sure if i understand how to apply it.

Thank you again.

[JohnTopley]

The hint I gave tells you exactly how to transfer the data into your summary table (as per your posted file).


You sheet reference for "September Quarter" needs to be put in single quotes: so A5 in sheet name of "Sheet XYZ" is referenced as 'Sheet XYZ!'!A5.

I cannot do anymore as I would be completing your work.

and to add the monthly data: SUM would be a good choice!

[vic.moon1]

ok, thank you for your help! Will try your hint!!!

[avk]

Dear vic
Ref atttach file & confirm.

[AliGW]

@ avk - as this is a homework task, you should not be providing the OP with a solution. Please review the forum rules on this.

[vic.moon1]

@ avk - as this is a homework task, you should not be providing the OP with a solution. Please review the forum rules on this.

I am not able to open your file. Sorry

[AliGW]

Vic - you really need to try to work this out for yourself from the hints offered. You will learn nothing by just using something that another person has done for you.

[vic.moon1]

Vic - you really need to try to work this out for yourself from the hints offered. You will learn nothing by just using something that another person has done for you.

Sure, that's fine! I think I got it now working! It takes some time

P.S. I have marked this post as "Solved".

Thank you in advance for your help

[avk]

vic : enter formula in "B5" as : =SUMIF(September_Quarter!$A$5:$A$9,$A5,September_Quarter!B$5:B$9) & copy paste accross (till "D5").
in "E5" as : =SUMIF(December_Quarter!$A$5:$A$9,$A5,December_Quarter!B$5:B$9) & copy paste accross (till "G5").

[zbor]

@avk:
Please do not ignore requests by Administrators, Moderators and senior forum members.


@vic.moon1:

Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

[vic.moon1]

Hi
Thank you for your message. The thread has been solved and I have marked the thread as solved in the beginning of its conversation. Sorry if it has caused so many issues...not sure how to close the thread now...

Apologize for any inconvenience.

[AliGW]

You do not need to apologise, Vic.

[zbor]

No problem vic.moon1.
You don't need to close it.
I'm glad if it's solved.

We would just like you to learn something of your workbook rather to get end solution

[vic.moon1]

Thanks
I have marked the thread as solved and still keep getting messages, confused now

Maybe the formulation of my question was wrong. I will keep your advises in mind for the next time

Thank you in advance for your help

[vic.moon1]

No problem vic.moon1.
You don't need to close it.
I'm glad if it's solved.

We would just like you to learn something of your workbook rather to get end solution

oh ok, got it now.
Thanks...It was great help anyway.