count multiple criteria

B

bob

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?
 
B

bob

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".
 
T

T. Valko

Try this:

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

Or:

D1 = person
E1 = dept

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

David Biddulph

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
 
Top