Count a range if cell meets the criteria in another cell

Hi everyone!

I have been trying to create a tracking sheet in excel which is really struggling at one point.

I have two sheets: one for data entry person to use and another is for summary to show how many quotes they have keyed in a day.

First sheet (for data entry):

A6 to A65536 will have dates in them.

E6 to E65536 will have serial numbers like 547-8745 (in this format)
F6 to F65536 will have serial numbers as well (like 874-896)

Second Sheet (for the summary)

B4 to B33 will have dates of a certain month. Let's say November.

Example:
B4 = 1 Nov 11
B5 = 2 Nov 11
B6 = 3 Nov 11

Now here is what challanges me:

I want to put number of serials entered for each day to C4 to C33 but couldn't figure out the formula.

So the formula is going to be in let's say C4. C4 is going to search B4(date) in sheet1 A6 to A65536. If it finds the date, it is going to count the serial number range for that specific date and place the number in C4.


To be absuletely clear:

Sheet1:

A6= 1 Nov 11 E6= 548-7454 F6= 547-5487
A7= 1 Nov 11 E7= 547-8745 F7= Blank
A8= 1 Nov 11 E8= Blank F8= 547-8756


Sheet2:

B4= 1 Nov 11 C4= 4

so I need to get that 4 somehow..

Any help will be hugely appreciated