Named list of sheets

[Ch. Kinnewig]

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

 

[Ch. Kinnewig]

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

 

[Bob Phillips]

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
(Insert>Name>Define 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)