General Betting
There is currently 1 person viewing this thread.
I have a spreadsheet recording all bets and I want a column that shows the strike rate of winning to losing bets.
How do I count the number of positive and negative values in a column and express the positive values as a percentage of the total cells in the column? Not interested in the values per se - just a count and a percentage. Ideally I would like to have a seperate column showing the running total for each cell.
Thanks
How do I count the number of positive and negative values in a column and express the positive values as a percentage of the total cells in the column? Not interested in the values per se - just a count and a percentage. Ideally I would like to have a seperate column showing the running total for each cell.
Thanks
sort by:
Show
per page
Replies: 6
|
By:
Say you have data in range F8:F12
This would give you percentage of negative numbers (change the cell format in excel to percent, and replace lessthan with the sigh, it does not show in the forum threads) =COUNTIF(F8:F12,"lessthan0")/COUNT(F8:F12) Similarly for positive numbers. |
|
By:
*sign ;)
|
|
By:
=IF(J160,K15+1,K15)
=IF(J161,L15+1,L15) If for example the result of each bet is in column J, then put this formula in cells K16 and L16, which represent the runnign totals of losing and winning bets. Wlog starting at row 16 In column M put =K16/(K16+L16) |
|
By:
Assuming the bets P&L starts in cell a2:
In b1 enter: =COUNTIF(A2:A65536,"0")/COUNT(A2:A65536) In b2 enter: =COUNTIF($A$2:A2,"0")/COUNT($A$2:A2) and drag this down all the way along your bets to give you a running total |
|
By:
snap
|
|
By:
Cheers, I'll try those out.
|