|
|
 Originally Posted by Bode-ist
thanks for all of the quick responses
the countif function only lets you put in one column for criteria, not 2.
the only sollution i had managed before was changing the Yes/No to 1/0 as cobere suggested. i think ill just do this for now.
CountIf will get the job done...eventually. It will likely take a couple of calculations. CountIf using one criteria, and then also Count the cells. Subtract and/or divide to get a percentage. It's getting complicated, but it's not that hard.
If you email me your sheet and spell out exactly what you would like it to do, I can set it up for you quickly and send it back.
***************************
For anyone else interested, I also have published my Bankroll Tracker free for anyone to pick up. It's not too complicated, though it does include a neat function to adjust automatically if you deposit in foreign currencies, and also has a place to keep track of BR spending.
EasyT's BankRoll Tracker (Excel)
Discussion of EasyT's BR Tracker
EasyT
|
Reply With Quote