Totaling cells from separate worksheets to master form

S

snake941

If I have 2 separate worksheets with individual cell values and want the
total to show the sum of obth cells, how do I do it?

Nelson
 
P

Pete_UK

Suppose those values are in F10 on one sheet and in G6 of the other
sheet, then put this in the appropriate cell of your master sheet:

=Sheet1!F10 + Sheet2!G6

to add them both together.

If your actual sheet names contain spaces you will need to include
apostophes around the sheet name, like:

='First Sheet'!F10 + 'Second Sheet'!G6

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio: copy text of a master shape to User-define Cells (Variable) 0
Cumulative formula for word table 0
Auto Populate One Pages from spreadsheet 0
Format column widths from one table to a separate table on same page 1
Access form continuous 1
Word macro that can call cells out of Excel for a find and replace 0
Consolidation Table from Different Excel Tabs with Different Format 1
Dumb question alert! What program to use? 0

Top