Excel 2007 : DCOUNTA or a better formula

[jkap]

I have a list of meetings (listed by row) with details for each meeting across several columns. I need to count how many meetings meet three criteria: Meeting Type, Meeting Location, and Date Range within a given month and year. Date range is what is causing my issue. Any suggestions?

[singerj6]

Assuming:
column A = Type
column B = Location
column C = Date

=COUNTIFS(A:A,Type Criteria,B:B,Location Criteria,C:C,">Lower Date")-COUNTIFS(A:A,Type Criteria,B:B,Location Criteria,C:C,">HigherDate")

Leave the quotes in for the date criteria ex. ">05/15/2012"

Hope it helps. Iif so please add to my rep by hitting the star in the bottom left hand corner, thanks.