Need help with Excel Formula.

I believe the formula needing to be used would some sort of Countif formula.

I need a formula for the following requirements: - Column F equals Cell C16 - Column G equals Cell C17 - Column D equals any one of cells in Cells D16:D18

I have highlighted the two accounts that match the criteria. The formula should say that there are 2, because there are only 2 rows that meet the criteria. Please put the formula in cell F17

F16 Discharge Date Claim Status 10/15/2016 Red 12/23/2016 Blue 12/3/2016 Green 11/11/2016 Orange 12/11/2016 Yellow 11/2/2016 Red 12/17/2016 Blue 1/17/2017 Green 1/18/2017 Purple 11/25/2016 Black 1/17/2017 Blue 10/31/2016 Red Claim Type Date Closed Last Modified By Auto Accident 8/15/2017 Megan Schott Auto Accident 2/21/2017 Megan Schott Auto Accident 11/1/2017 Samantha Huckaby Auto Accident Auto Accident 3/8/2017 Megan Schott Auto Accident 11/1/2017 Megan Schott Auto Accident 3/31/2017 Megan Schott Auto Accident 11/1/2017 Megan Schott Auto Accident 2/24/2017 Megan Schott Auto Accident 6/27/2017 Megan Schott Auto Accident 11/1/2017 Deyaneira Perez Auto Accident 8/28/2017 Samantha Huckaby 4 Megan Schott 10 12 13 11/1/2017 Red Megan Schott Blue 16 17 18 19 Green