I need to create a summary worksheet totaling 4 worksheet pages each with many cells. How do I do this?

Hi Andy

I'm AnnaThomas and I'd be happy to help you with your question. In this Forum, we are Microsoft consumers just like yourself.

You can follow these steps:

Open Microsoft Excel and create a new workbook.

Create four separate worksheets, by clicking the "+" icon at the bottom of the screen, and name them accordingly.

On each worksheet, enter the data that you want to include in your summary.

On the summary worksheet, select the cell where you want to start your table.

Go to the "Data" tab in the ribbon and select "Consolidate".

In the "Function" field, choose the appropriate function, such as "SUM" or "AVERAGE".

In the "Reference" field, select the range of cells you want to include in your table.

Repeat steps 5-7 for each of the four worksheets.

To move to the next page, click the "+" icon at the bottom of the screen.

Repeat steps 4-8 on the new page.

Continue until you have consolidated all four worksheets into your summary.

Adjust formatting and add any necessary charts or graphs to enhance the presentation of your data.

Save your workbook and print or share your summary worksheet as needed.

These steps should help you create a summary worksheet that totals four pages with many cells.

I hope this helps ;-), let me know if this is contrary to what you need, I would still be helpful to answer more of your questions.

Best Regards,

AnnaThomas

Give back to the community. Help the next person with this problem by indicating whether this answer solved your problem. Click Yes or No at the bottom.

Thank you for the assistance and wonderful directions! They were spot on and worked great. I was able to complete the project by easily following your directions. What a time save! Thanks again!