1. number of wedding banquets: = countifs ($ a $2: $ a $8, F2, $ b $2: $ b $8, "wedding banquets")

2. Amount of the wedding banquet: = sumifs($ c $ 2:c $8, $ a $ 2:a $8, F2, $ b $ 2:b $8, "wedding banquet").

3.？ Number of birthday parties: = if (countifs ($ a $2: $ a $8, F2, $ b $2: $ b $8, "birthday parties") = 0, "",count ifs($ a $ 2:a $8, F2, $ b $2: $ b).

4.？ Birthday party amount: = sumifs($ c $ 2:c $8, $ a $ 2:a $8, F2, $ b $ 2:b $8, "birthday party")

The formula results are as follows:

Graphical representation of formula results