Countif + vLookup: Can they work together?

S

Spyder

Can I set a countif function to count the number of times a name i.e. "Jim"
appears in column B in any worksheet in a single workbook where the value in
the same row of column E equals "Assigned"?

Thanks for any help!
Jeff
 
P

prague

I believe this formula can help you to get you want. Extend the range to
your needs ...

{=SUM(IF(B2:B1000="Jim",IF(E2:E1000="Assigned",1,0)))}
 
P

prague

=SUM(IF(A2:A7="Buchanan",IF(B2:B7=9000,1,0)))

Input this into the cell you want the result to appear, Press "F2" the
Ctrl+Shift+Enter

Will show you the results ... :
 
Top