Count pending issues prior to 1/15/2009

V

Vic

What is the formula to count "pending" issues (cells K2 thru K3015) that were
supposed to be resolved by "1/15/2009" (cells H2 thru H3015)?
K2:K3015 = "Pending" and H2:H3015 < 1/16/2009

Thank you.
 
M

Mike H

Hi,

Try this

=SUMPRODUCT((H2:H3015<DATEVALUE("16/1/2009"))*(H2:H3015<>"")*(K2:K3015="Pending"))

Mike
 
P

Pete_UK

Try this:

=SUMPRODUCT((K2:K3015="Pending")*(H2:H3015<DATE(2009,1,16))*
(H2:H3015<>""))

Hope this helps.

Pete
 
Top