Named list of sheets
 

Sorry for mingling in that discussion.

I was trying this solution, but I confess having no idea to form a "named
list of sheets".

Could you pls. give a hint?

Thanks,
Charlotte

Am Tue, 01 Mar 2005 10:38:50 +0100 schrieb Ch. Kinnewig:

Ooops - sorry again (struggling with my new newsreader)


=SUMPRODUCT(COUNTIF(INDIRECT("'"&Sheets&"'!A1:A10 "),"training"))

where Sheets is a named list of the sheets to count over, and it is an
array formula, so commit with Ctrl-Shift-Enter.


I was trying this solution, but I confess having no idea to form a "named
list of sheets".

Could you pls. give a hint?

Thanks,
Charlotte

Charlotte,

This would be a simple list of the names of the sheets that the counting is
to affect, in a column say, and then given a workbook name
(InsertNameDefine Name...) of Sheets. This will then present an array to
SUMPRODUCT that it can work on, one by one effectively.

--

HTH

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


"Ch. Kinnewig" wrote in message
...
Am Tue, 01 Mar 2005 10:38:50 +0100 schrieb Ch. Kinnewig:

Ooops - sorry again (struggling with my new newsreader)


=SUMPRODUCT(COUNTIF(INDIRECT("'"&Sheets&"'!A1:A10 "),"training"))

where Sheets is a named list of the sheets to count over, and it is an
array formula, so commit with Ctrl-Shift-Enter.


I was trying this solution, but I confess having no idea to form a "named
list of sheets".

Could you pls. give a hint?

Thanks,
Charlotte