LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum of results of multiple criterias Alex Excel Worksheet Functions 3 April 2nd 09 05:36 PM
Help with counting two different criterias. Jboo Excel Discussion (Misc queries) 9 February 24th 09 08:50 PM
Count with multiple criterias Lene S Excel Worksheet Functions 8 December 10th 07 03:31 PM
Counting instances based on two criterias [email protected] Excel Worksheet Functions 7 June 5th 06 07:18 PM
Counting cells if special criterias are true a94andwi Excel Worksheet Functions 12 May 2nd 06 07:07 AM


All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"