View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Munster Munster is offline
external usenet poster
 
Posts: 10
Default Help with Counting Multiple Criterias

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