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