I am trying to create a COUNTIF statement that will reference
three columns (random dates, repetitive names, repetitive text)
and have three criteria checks. For example:

Column A: May 1, May 15, *June 1*
Column B: Bob, Tom, *Bob*
Column C: Pending, Closed, *Closed*

The rows would associate May 1 -- Bob -- Pending together along
with an unknown number of total rows.

The target cell with the criteria checks will need:
a) to reference TODAY() and pass if between 1-5 days,
b) the criteria will only pass if persons name is "Bob", and
c) the project status has to be "Closed"

if any of these criteria fail, the row cannot be counted. In this
example,
row 3: June 1, Bob, Closed passed all three and would be counted.

I know the coding is incorrect, but I'm really banging my head against
the
wall to figure out -- and this is the closest I can give for an
example:

=countif((countif(A:A, "1")+countif(A:A,,"<6")) AND
countif(B:B,"*BOB") AND countif (C:C,"*Closed"))


Please help me.... I'm losing my mind.... :)


--
Malvaro
------------------------------------------------------------------------
Malvaro's Profile: http://www.excelforum.com/member.php...o&userid=29589
View this thread: http://www.excelforum.com/showthread...hreadid=547943