Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumif? countif? | Excel Worksheet Functions | |||
From SUMIF to COUNTIF | Excel Worksheet Functions | |||
function question (sumif countif conditional) | Excel Worksheet Functions | |||
Countif, Sumif | Excel Discussion (Misc queries) | |||
Countif/Sumif function question | Excel Worksheet Functions |