Multiple Criteria Formulas

J

Jason

I would like to create a formula to give me the number of
cells that meet two criterias: Employee Department Number
(e.g., "210") AND Employee Location (e.g., "CA"). I have
tried different varities of Countif & If functions, but
can not get it to work...anyone have a idea how to do
this????

THANKS!!
 
Top