Did you create a named list of the sheets to count over?

--

HTH

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


"marcie" wrote in message
...
hi bob ...sorry, i am getting the error msg #name .. i input
sumproduct(countif(indirect("'"&feb1:feb5&'!a3:m37 "),"training"))
....sorry,sue

"marcie" wrote:

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