Counting rows with 2 conditions (countif?)

[psycoperl]

I have data in my workbook on the "Roster" worksheet, where in a column P I have the session date and in column Q I have the session time.

On my "summary" worksheet , I want to have a count of how many rows meet a specific condition in both Column P and Q.

I was planning on using the =CountIf() function with =CountIf(ROSTER!P2:Q2200, ...) but can not figure out how to set the conditions.

For example. Where in Col. P = 10/13/2009 and Where Col Q = 9:30.

Any guidance would be appreciated.

 

[rassten]

Hi
Maybe something like this:

Excel Workbook
	A	B
1	Day	Time
2	10/12/09	09:30
3	10/12/09	09:30
4	10/12/09	09:30
5	10/13/09	09:30
6	10/13/09	09:30
7	10/13/09	09:30
8	10/14/09	09:30
Roster

Excel Workbook
	A	B	C
1
2	10/13/09	09:30	3
3
Summary