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