Adding Cells from Multiple Sheets

[Guest]

I know the subject line seems like an easy thing so please read this all
before you asnwer. I have a spreadsheet with 60 tabs. On each tab in cell
F36 I have a countif statement that looks like: =countif(D638,"C"). What
I'd like to do is add up the countif statements from all 60 tabs to summarize
that number on another sheet. I started writing something that looks like:
='ALBQ.QWT.1'!F36 + 'ALBQ.QWT.2'!F36 + so on and so forth, but I have 13
spreadsheets with 60 tabs each. As you can see it's kind of a large task to
do manually.

My question is; can I do something programatically to add all of these cells
up without having to write the huge addition statement?

Any help would be greatly appreciated!!!!

Thanks,

KG

 

[Daniel CHEN]

You can use function SUM, but need a little trick.
1) In the results sheet, type: " =sum( "
!Do not use Enter key after "("

2) use shift and/or ctrl key and mouse to select all the 60 sheets tabs
3) use mouse to select cell F36
4) type ") "

You formula should look like:
=SUM('ALBQ.QWT.1:ALBQ.QWT.60'!F36)

Or

You can directly type the formula like:
=SUM('ShtLeftMost:ShtRightMost!F36)
ShtLeftMost is the sheet name of the left most tab and ShtRightMost is the
sheet name of the right most tab.

===== * ===== * ===== * =====
Daniel CHEN

Spreadsheet/VBA Specialist
(e-mail address removed)
www.Geocities.com/UDQServices
Your "Impossible" Task Could Be Someone Else's "Piece of Cake"
===== * ===== * ===== * =====

 

[Tom Ogilvy]

=Sum('ALBQ.QWT.1:ALBQ.QWT.30'!F36)

 

[Guest]

Tom and Daniel --

Thank you so much for this "easy" fix!! It works like a champ and has saved
me (and my fingertips) a lot of time and effort.

Thanks again,

Kevin G