Hi!

I'm not sure what you mean by:

would it be possible to link books together in a format
like that?

Can you be more specific?

One thing you'll notice is the use of the Indirect
function in the formula examples. You can link between
WORKBOOKS using Indirect, however, Indirect REQUIRES that
the other workbook be open otherwise you'll get an error.

Biff

-----Original Message-----
Thank you Biff, that will help me in a project I will
soon work on.

To make it more difficult, would it be possible to link
books together in a
format like that?
Such as Patient 1011.xls, and Patient 1012.xls
Pull particular information from those books into one
easy to read sheet?

Thank you in advance.

"Biff" wrote:

Hi!

If you use the default sheet names: Sheet1, Sheet2,
Sheet3, etc ....

Assume you want to Countif B1:B10 equals 10 on sheets
2:10

=SUMPRODUCT(COUNTIF(INDIRECT("Sheet"&ROW(INDIRECT
("2:10"))
&"!B1:B10"),10))

If you use custom sheet names ....

List the sheet names in a range, say H1:H9

=SUMPRODUCT(COUNTIF(INDIRECT(H1:H9&"!B1:B10"),10))

Biff


.