=SUMPRODUCT(--(INDEX("'"&A2&"'!$B$2:$B$12000")=D2),--(INDEX("'"&A2&"'!$H$2:$
H$12000")="1"))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Al" wrote in message
...
I attempted to build a pivot table to do this but the formatting will not
do
what I need and there is to much data for the pivot table to handle. (It
runs out of columns with only 1/4 of the data on the table...)

I need to have a pull down menu at the top of the page with the 6 data
tabs
as the options. I need my formulas to look on the tab that is selected.
Here is the formula in question:

=SUMPRODUCT(--('Data 1 Month'!$B$2:$B$12000=D2),--('Data 1
Month'!$H$2:$H$12000="1"))

So instead of 'Data 1 Month' I want it to check a cell that I specify,
which
will be references to my data tabs, and look there.