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(D6:D38,"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

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

www.Geocities.com/UDQServices
Your "Impossible" Task Could Be Someone Else's "Piece of Cake"
===== * ===== * ===== * =====



"Kevin G" wrote in message
...
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(D6:D38,"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

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

--
Regards,
Tom Ogilvy



"Kevin G" wrote in message
...
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(D6:D38,"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

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

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy



"Kevin G" wrote in message
...
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(D6:D38,"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