Checking for how many occurances, given two different criteria

  • Thread starter Thread starter rachelplevinsky
  • Start date Start date
R

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!
 
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.
Click to expand...

try COUNTIFS or SUMPRODUCT

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


Regards
Claus B.
 
Back
Top