Add up worksheets

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

I have 30 worksheets in one workbook I need to add cell F26 from each sheet
and add them up in sheet 31. Is this possible?
Thanks Kate
 
=SUM('Sheet1:Sheet30'!F26)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Thanks Bob it does help

Kate
Bob Phillips said:
=SUM('Sheet1:Sheet30'!F26)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
You must log in or register to reply here.

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

Adding values that fall between 2 dates 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
RE add cells together if value has a formula 1
retrieve data from different workbook 1
Assigning a Worksheet Name to a Cell 4
how do I apply formatting from one worksheet to a whole workbook? 5
Pulling/Collating Data from Workbooks 6

Back
Top