....perhaps US date format ???

"Richard Buttrey" wrote:

On 31 Aug 2006 09:23:40 -0700, "Ted McCastlain"
wrote:

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!

Unless I'm missing something obvious the following will tell you the
number of completed Proposals. Alter as necessary for the number of
RFPs and change the last term to ="" to indicate the number of pending
items.

=SUMPRODUCT((B3:B100="PROPOSAL")*(A3:A100="P"))


Just an observation, but isn't column A redundant since you only have
a "P" when there is an entry in the Date completed.

In which case change the formula to

=SUMPRODUCT((B3:B100="PROPOSAL")*(E3:E100=""))

and get rid of the data in column A.

Incidentally why were some of the date formats different. some were
d/m/y others are m/d/y ?

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________