Count IF Q.
 

Hi,
I have two columns F & G
Column F has the Vacation Status of group of employees €œProcessed€� or
€œScheduled€� start from F7 to F83
Column G has the date of vacation starts, start from G7 to G83
What I want to do is to count the numbers of employees who have €œProcessed
€œstatus and before 06/30/2007
Your help is highly appreciated
Thanks!!

Count IF Q.
 

=SUMPRODUCT(--(F2:F200="Processed"),--(G2:G200<""),--(G2:G200<--"2007-06-30"))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jon" wrote in message
...

Hi,
I have two columns F & G
Column F has the Vacation Status of group of employees "Processed" or
"Scheduled" start from F7 to F83
Column G has the date of vacation starts, start from G7 to G83
What I want to do is to count the numbers of employees who have "Processed
"status and before 06/30/2007
Your help is highly appreciated
Thanks!!