I have the following table:

Column A - Date. The date is only listed for line number 1, but
applies to all lines until the next date.
Column B - Line (machine) number
Column C - Pounds of scrap
Column D - Reason code for the scrap. This is always from a short list
of specific words.

The following headers begin on line 5.

Date | Line | Scrap Lbs | Scrap Reason
1/1        1       23                 Equipment
            2       18                  Power failure
            3         0                
            4       20                  Graphics

1/2        1        0                
            2       77                  Power failure
            3         0                
            4       42                  Heater broke

1/3        1        0                
            2       33                 Graphics
            3       40                 Broken wire
            4       93                 Motor stopped

The table continues covers the entire year and there are actually 9
machines.

I want to extract a report from the data by selecting the machine
number, then select a beginning and ending date and an optional reason
code.

Rows 1through 4 are used for a report as follows:

Row 1 - Report headers as:
A1 - Line number
A2 - Beginning Date
A3 - Ending Date
A4 - Scrap Reason

Row 2 is the search input for the headers in row 1.
Row 3 is where the results will output. Specifically, C4 would be the
total pounds of scrap for the line (machine) specified in B1 and for
the date range given in B2 through B3 inclusive and matching the scrap
reason code specified in B4.

For example, if I put the following in row 2:

B1 - 3
B2 - 1/10/07
B3 - 4/23/07
B4 - Graphics

The formula in C4 would look for all matches of line 3 between the
dates of January 10th through April 23rd, inclusive, and matching the
scrap reason "Graphics."

I would also like the show the total number of occurrences in C5.

Is this possible with a formula in the cell?

Thanks