Count the numbers of line items based on a criteria

[sn152]

Good Evening All,
I require a formula which can count the number of line items with a given criteria. So I have 2 sheets. 1st sheet has got 4 columns (Queue type, State, Status, Date). One the second sheet I have to add a formula in the column C and F for the cells highlighted in yellow.

For CO state - it should count the number of line items based on each "queue type" and "status". There are only 2 status - HOLD and FAQ. Also I require the oldest date column in the sheet 2 to be filled automatically based on the oldest date of the state and the queue type and status.

Please help me with this...

Thanks in advance.

[JBeaucaire]

C10: =COUNTIFS(Sheet1!$B:$B, $A$2, Sheet1!$A:$A, Sheet2!$B10&"*")
F10: =COUNTIFS(Sheet1!$B:$B, $A$2, Sheet1!$A:$A, Sheet2!$B10&"*", Sheet1!$C:$C, Sheet2!F$1)
H10: =LOOKUP(2, 1/((Sheet1!$B$2:$B$200=$A$2)*(LEFT(Sheet1!$A$2:$A$200, LEN($B10))=$B10)), Sheet1!$D$2:$D$200)