Here is what I need to do:

I need to count the number of "Proposals" and the number of
"RFP" separately and those two values are contained within the same
column. Then I need cross reference that to the date completed column.
Here is the problem I am running to. I can count the number of RFP
and Proposals using the COUNTIF function but I cannot figure out a way
to determine which number of proposals and RFPs are complete or
pending. I am referencing the data to dates inputted into another
column.

The "P" represents a check mark showing the task complete.

P Type Start Date Due Date Completion Date


P PROPOSAL 02/22/06 04/01/06 04/30/06
P PROPOSAL 04/03/06 04/05/06 04/05/06
PROPOSAL 04/03/06 04/05/06
P RFP 03/30/06 04/07/06 04/04/06
P PROPOSAL 04/07/06 04/10/06 04/10/06
P RFP 04/07/06 04/11/06 04/11/06
P RFP 04/17/06 04/24/06 04/24/06
RFP 04/28/06 05/01/06
Thanks for the help!