Op dinsdag 14 maart 2017 19:38:39 UTC+1 schreef Munster:
Hello,
I am in need of a formula that will count how many times baseball was played and won. I keep Value errors and N/A errors when I try formulas like countifs, sumif, sumifs etc.

A B
1 Baseball Result
2 Football Win
3 Soccer Win
4 Bowling Win
5 Tennis Win
6 Ping Pong Win
7 Billiards Win
8 Baseball Win
9 Football Loss
10 Soccer Win
11 Bowling Loss
12 Tennis Loss
13 Ping Pong Win
14 Billiards Win
15 Billiards Win

Zijn dit nu twee of drie kolommen?