View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bindy Bindy is offline
external usenet poster
 
Posts: 1
Default COUNTIF or SUMIF question

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
--
Thanks,
Bindy