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

Question

I have a table as follows:

A	B	C
1	happy	1-veggies
1	sad	1-veggies
2	angry	2-meat
2	sad	2-meat
3	sad	2-veggies
4	moody	2-meat
4	thoughtful	2-meat
5	excited	2-meat

Answer 1

Use SUMPRODUCT

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