Sounds like you want to do a SUMIF across multiple sheets.

Try this:

Make a list of your sheet names in say, A1:A11.

This will sum B1:B10 if A1:A10 on any of the sheets listed contain the
account number XX:

=SUMPRODUCT(SUMIF(INDIRECT("'"&A1:A11&"'!A1:A10"), "XX",INDIRECT("'"&A1:A11&"'!B1:B10")))

If the account number is a numeric number like 9999 do not enclose it in
quotes. If the account number is an alpha-numeric like X99C then do enclose
it in quotes.

--
Biff
Microsoft Excel MVP


"Elise148" wrote in message
...
Well, what I'd like to do is check a table in 11 different sheets for a
specific account number and have a formula add all the amounts in a column
that relate to that account...

"Don Guillett" wrote:

More detail???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Elise148" wrote in message
...
Is there a way to do a vlookup using mulitple table arrays? I tried,
and
couldn't get it to work, but maybe I wasn't doing it the right way...