sum question

S

sanj

I have 20 tabs in my excel file.I need to check sum of
numbers in cell A14 for all 20 tabs.Instead of going to
each tab and adding A14 cell for each tab , is there any
formula or trick to get total? thanks for the help

Sanj
 
G

Guest

What if that does not work? I only have two tabs and typed the formula
exactly how it appears below and it is still not working. Instead it is
saying #NAME?

any help is appreciated.
 
J

JulieD

Hi Tony

the formula supplied by Jason assumes that your sheets are called
Sheet1:Sheet20
so you'll need to replace the Sheet1 and Sheet20 with the actual names of
your sheets - note, if you have spaces in your sheet names you'll need to do
it like this:

=SUM('my first sheet:my second sheet'!A14)

note the apostraphe ' before the start of the first sheet name and at the
end of the second sheet name

also it's not easy to see but theres a colon : between the sheet names

Cheers
JulieD
 
G

Guest

Julie,
Thanks. Here is how I wrote it: =sum('sheet1:sheet2'!E11)

Now it is saying #REF!

I really appreciate the help.
 
G

Guest

I got my answer. I feel really stupid here. But my tabs actually had names
as opposed to "sheet" once I filled the names in on the formula it worked.
Thanks for your help.
 

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

Sum Worksheets 7
sum if and sum if 4
Lookup text in array & return cell reference 5
Calculating sum product between columns. 3
formula to display cell address 2
Counting the number of cells between 2 seperate cells 2
average calculation 1
Excel Counting unique values in Excel, based on criteria. 5

Top