count &vlookup

[marcie]

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

 

[Bob Phillips]

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

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

 

[Bob Phillips]

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

--

HTH

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

 

[marcie]

hi .. sorry, no .. i will do that .. i apologize ..thanks,sue