COUNTIF or SUMIF question

  • Thread starter Thread starter Bindy
  • Start date Start date
B

Bindy

I'm not certain if this a possibilty, but I am not able to figure it out on
my own. I am trying to count cells (with text only) in one worksheet to have
the total appear in another sheet, same book.

I want the total of how many times ReqDept (A2:A6) appears for each Mod
(B2:B6). For instance how many times MR & GYN match =2; MR & ENT =1. What
would be the correct formula to write?

Example
............A.........B
1 ReqDept Mod
2 MR GYN
3 CT ENT
4 MR ENT
5 MR GYN
6 US PMR
 
Bindy,

Try this with the 2 values your trying to countt matches for in C1 & D1

=SUMPRODUCT((A2:A6=C1)*(B2:B6=D1))

Mike
 
Back
Top