count multiple criteria
 

I saw a post with this question, but it had a sumproduct function. I need to
count the number of instances with a certain person, and from a certain
dept. I just want to count these. Is this possible?

count multiple criteria
 

Yes.
--
David Biddulph

wrote in message news:h_muj.39584$9j6.38777@attbi_s22...
I saw a post with this question, but it had a sumproduct function. I need
to
count the number of instances with a certain person, and from a certain
dept. I just want to count these. Is this possible?

count multiple criteria
 

I tried the formula used in the earlier example. I dont' know why it works
but it does. You provided it I think so.....thanks. Not for the "yes".

count multiple criteria
 

Try this:

=SUMPRODUCT(--(A1:A10="person"),--(B1:B10="dept"))

Or:

D1 = person
E1 = dept

=SUMPRODUCT(--(A1:A10=D1),--(B1:B10=E1))


--
Biff
Microsoft Excel MVP


wrote in message news:h_muj.39584$9j6.38777@attbi_s22...
I saw a post with this question, but it had a sumproduct function. I need
to
count the number of instances with a certain person, and from a certain
dept. I just want to count these. Is this possible?

count multiple criteria
 

If you are trying to reply to a message on this thread, please quote enough
of the context for readers to see to what and to whom you are replying. If
there is a formula that you don't understand, first look in Excel Help for
any functions that you don't understand. Also look at previous messages on
this group where similar formulae may well be explained (or where there may
well be pointers to web pages which explain particular constructs). If
there is still something you don't understand, explain in detail what it is
you don't understand, and then someone will probably try to help you.

More hints & tips at http://www.cpearson.com/excel/newposte.htm
--
David Biddulph

wrote in message news:C9nuj.39666$yE1.9244@attbi_s21...
I tried the formula used in the earlier example. I dont' know why it works
but it does. You provided it I think so.....thanks. Not for the "yes".