=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.

--

HTH

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


"marcie" wrote in message
...
hi ... i am trying to count daily job functions, then do a weekly &
monthly
count from the daily worksheets. i have tried various formulas with no
success ie:weekly =countif(feb1:feb6,"training") or
=vlookup(a3,feb1:feb6!$a$30:$c$30,3,0) and receive error msg..I appreciate
any help,please, thanks sue