Checking for how many occurances, given two different criteria

[rachelplevinsky]

Hi--

I am trying to count the number of times a given title shows up in excel, given the criteria of department (which is a number) and job title (a word).

I have tried several different formulas and it either gives me and error, the formula isn't correct, or just the number zero.

I was wondering if anybody had any ideas about how to do this?

Thanks!

 

[Claus Busch]

Hi,

Am Tue, 10 Jun 2014 13:31:07 -0700 (PDT) schrieb
(e-mail address removed):

I am trying to count the number of times a given title shows up in excel, given the criteria of department (which is a number) and job title (a word).

I have tried several different formulas and it either gives me and error, the formula isn't correct, or just the number zero.

try COUNTIFS or SUMPRODUCT

Or explain in which columns your values are and post an example of your
values.


Regards
Claus B.