Thanks Toppers.
Complete mental blockage today - put it down to anaesthetic still in
system from recent hospital visit!!!

--
Regards

Roger Govier


"Toppers" wrote in message
...
Re Roger's reply:

With SUMPRODUCT you cannot specify complete columns so use B1:B1000
(for
example)

=SUMPRODUCT(--(B1:B1000="PROPOSAL"),--(ISBLANK(E1:E1000)))


"Roger Govier" wrote:

Hi Ted

One way
For NOT completed Proposals
=SUMPRODUCT(--(B:B="PROPOSAL"),--(ISBLANK(E:E)))
For Completed proposals
=SUMPRODUCT(--(B:B="PROPOSAL"),--(NOT(ISBLANK(E:E))))

Change text to "RFP" to deal with your not completed and not
completed
RFP's
--
Regards

Roger Govier


"Ted McCastlain" wrote in message
oups.com...
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!