０ｏ０ｄグッ

COUNTIFS

COUNTIFS

ABC
1出あ
2出いお
3出うか
4出え
5出
6欠
7欠
8欠
9
1042
11↑↑
12│=COUNTIFS(A1:A8,"出",B1:B8,"*")
13=COUNTIFS(A1:A8,"出",C1:C8,"*")