LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sumif? countif? Aaron Hodson \(Coversure\) Excel Worksheet Functions 3 September 3rd 08 04:35 PM
From SUMIF to COUNTIF Jennie Excel Worksheet Functions 0 June 18th 08 12:37 PM
function question (sumif countif conditional) Norbert Excel Worksheet Functions 0 February 25th 08 09:37 PM
Countif, Sumif tamato43 Excel Discussion (Misc queries) 2 March 22nd 05 08:55 PM
Countif/Sumif function question psyd Excel Worksheet Functions 0 November 5th 04 06:09 AM


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"