Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 9th October 2008, 01:14 PM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 446
Red face Spreadsheet help

I am currently creating a excel database of all the races I have ratings for.
I have entire fields of each race, and am just writing in the win and place divis is columns across from the appropriate horse (top 3 only). What I want is to be able to tally up the number of winners in each column to get my strike rate. Having around 1000 races at this stage, it is to much effort to count through how many times they won. Hope I have explained enough, if not will try and post a example if none of this mean anything to anyone.
Reply With Quote
  #2  
Old 9th October 2008, 01:24 PM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 446
Default

Heres an example. The winner has come from the top 3 in all races. How can I tally up how many time there is a entry in column G. If I lost a race, column G is blank.
Attached Files
File Type: xls exmple.xls (60.0 KB, 678 views)
Reply With Quote
  #3  
Old 9th October 2008, 02:21 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

If you change the word "won" to say 1 you could just use at the bottom =count(g1:g1000) this will add up the total.
Reply With Quote
  #4  
Old 9th October 2008, 02:56 PM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 368
Default

=COUNTIF(G:G,"won")
Reply With Quote
  #5  
Old 9th October 2008, 03:08 PM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 446
Default

Quote:
Originally Posted by Crackone
=COUNTIF(G:G,"won")
Gave that a try, but it didnt like it. I am using Open Office, so perhaps that could be why?
Reply With Quote
  #6  
Old 9th October 2008, 03:14 PM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 446
Smile

Ahh got it,

=countif(g1:gxxx;"won")

Cheers crackone
Reply With Quote
  #7  
Old 9th October 2008, 03:14 PM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 368
Default

Quote:
Originally Posted by thorns
Gave that a try, but it didnt like it. I am using Open Office, so perhaps that could be why?
Could be ???? don't now open office but thought you could use the formulas
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 02:20 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655