我想寫 excel formula 數 a1:a10 內的 "present" 字, 而且要 c1:c10 內的 "boy" 字 (ANS is 2)
請問如何寫?
a b c
1 present 13 boy
2 present 14 girl
3 abesent 13 boy
4 present 14 girl
5 abesent 14 girl
6 absent 13 boy
7 absent 13 boy
8 present 14 girl
9 present 13 girl
10 present 13 boy