count &vlookup
 

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

=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

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

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

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

"Bob Phillips" wrote:

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