[Solved] Excel count rows where column B and C equals value and value in column A is a duplicate

Use SUMPRODUCT

=SUMPRODUCT((B1:B8="Sad")*(COUNTIF(A1:A8,A1:A8)>1)*(ISNUMBER(SEARCH("veggies",C1:C8))))