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.

" wrote:

Thanks Jason works great!!
-----Original Message-----
=SUM(Sheet1:Sheet20!A14)

HTH
Jason
Atlanta, GA

-----Original Message-----
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
.

.