Adding Cells from Multiple Sheets
=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
|