Multiple Criteria Formulas

  • Thread starter Thread starter Jason
  • Start date Start date
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!!
 
Here is an answer I gave someone else today. Adapt to your needs.

IF I understand your needs
=sumproduct((rngA="Term 1")*(rngC="dropped)*1)
example
=SUMPRODUCT((A2:A200="term 1")*(C2:C200="dropped"))
if you have numbers in col a
=SUMPRODUCT((A2:A200=1)*(C2:C200="dropped"))
for new students that dropped
=SUMPRODUCT((A2:A200="term 1")*(B2:B200="new")*(C2:C200="dropped"))
 
Back
Top