Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions | |||
Count If Formula | Excel Worksheet Functions | |||
count based on two fields - need quickly | Excel Worksheet Functions |