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: 68
Default Compound Criteria for CountIf

Excel 2003

I have a worksheet with the following data in cells B7:C12.

Dept. Date
DOC 11/13/2008
DOT 12/1/2008
AGR 12/12/2008
AGR 12/23/2008
AGR 1/10/2009
DOJ 2/10/2009

I need a way to count all the occurrences for a given department name that
fall into a given date range. For example, I need to count all the entries
for "AGR" in the month of December. Using COUNTIF() I can count all
occurrences of "AGR", but I can't figure out how to get just the ones in the
month of December.

Currently, the file is very small, but it may well grow to be thousands of
lines, so I need a solution that will perform well for a large amount of
data.

Any help that you can offer will be greatly appreciated.

--Tom


 
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
Compound CountIf formula Pete Rooney Excel Worksheet Functions 5 April 16th 08 05:38 PM
Compound condition with COUNTIF Mike McLellan Excel Discussion (Misc queries) 1 November 29th 05 10:50 AM
Countif using format criteria not number criteria? Rumbla76 Excel Worksheet Functions 1 April 20th 05 05:38 AM
Countif using format criteria....not number criteria? Troy Excel Worksheet Functions 1 April 20th 05 04:50 AM
COUNTIF with compound comparison Thermometer Excel Worksheet Functions 1 March 28th 05 04:15 PM


All times are GMT +1. The time now is 08:14 AM.

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"