Count the number of times a data appear based on multiple criteria between 2 dates

Hi,

I need to build a spreadsheet based on the submitted data of our lead source. Below is my problem:

I need to count how many times A2 appear on K:K based on Status in A:A between the date in B4 and B5 . I'm always getting an error when I used countifs and sumproduct and not sure how to proceed.

The Attached spreasheet is just a sample but it will be a database that I need to do.

This is the formula I'm trying to use but getting error
=countifs(K1:K4, A2, F1:F4, B1,J1:J4 <=B4, J1:J4>=B5)

Thank you for anyone who will answer this.

1. Are you still running 2007? If you have upgraded, please update your profile as this may make a difference in the solution provided
2. We are unable to manipulate data in a picture. Please read the banner at the top of this page and supply a sample worksheet and mocked up solution so we clearly understand your needs.

Are you still running 2007 as asked earlier. Your answer will help to determine the correct solution.

This formula should work, but only after you change your dates from Text to actual Dates (numbers).

=COUNTIFS(K2:K4, A2, F2:F4, B1,J2:J4,">=" & B4, J2:J4, "<=" & B5)