Count pending issues prior to 1/15/2009

[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.

 

[Mike H]

Hi,

Try this

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

Mike

 

[Pete_UK]

Try this:

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

Hope this helps.

Pete