My formula for the question =COUNTIFS('Customer Information'!E9:E34,'Dish Information'!B3,'Customer Information'!$H$9:$H$34,'Customer Information'!H9) Only works for the first cell ( F3) but when I copy it down it doesn't give the correct answers.

Cells F3:F12: - In cell F3, calculate the total number of orders that qualified for a discount for each dish. - Fill your formula down to F10. - **Hint: the COUNTIFS formula will prove useful