New Posts For Thread: excel hekp pleasehttps://community.betfair.com/exchange_games/go/thread/view/94066/23453482/excel-hekp-pleaseI am trying to achieve the following, count the no. of t's and place the no. in the adjacent cell, resetting after each set of t's when a blank cell is encountered....basically to count the no. of t's between two blank cells...i am just learning exceplease follow this thread in the poker forum to contribute....thank youhttps://community.betfair.com/exchange_games/go/thread/view/94066/23453482/excel-hekp-please?post_id=418845238#418845238please follow this thread in the poker forum to contribute....thank youMon, 28 Dec 2009 10:54:17 -0600hello fine as frog.....i have been given the solution in poker forum however i am trying to do a sum of the numbers in the column but it won't work whereas if i type in the no.s in a separate column and use the sum function it works fine...any advicehttps://community.betfair.com/exchange_games/go/thread/view/94066/23453482/excel-hekp-please?post_id=418845234#418845234hello fine as frog.....i have been given the solution in poker forum however i am trying to do a sum of the numbers in the column but it won't work whereas if i type in the no.s in a separate column and use the sum function it works fine...any adviceMon, 28 Dec 2009 09:14:39 -0600i stand corrected...thank youhttps://community.betfair.com/exchange_games/go/thread/view/94066/23453482/excel-hekp-please?post_id=418845230#418845230i stand corrected...thank youMon, 28 Dec 2009 08:55:08 -0600No it doesn't.Can't help you anymore as you don't seem to be able to grasp the basics of writing a formula.eg the formula will give you 1 if there is a " t " in row 2 and will give you 2 if there is another in row 3 etc etc.https://community.betfair.com/exchange_games/go/thread/view/94066/23453482/excel-hekp-please?post_id=418845202#418845202No it doesn't.Can't help you anymore as you don't seem to be able to grasp the basics of writing a formula.eg the formula will give you 1 if there is a " t " in row 2 and will give you 2 if there is another in row 3 etc etc.Mon, 28 Dec 2009 01:58:37 -0600it just puts a 1 opposite a t and not the subtotal...eg eg 2 t's in a row =2 etchttps://community.betfair.com/exchange_games/go/thread/view/94066/23453482/excel-hekp-please?post_id=418845194#418845194it just puts a 1 opposite a t and not the subtotal...eg eg 2 t's in a row =2 etcSun, 27 Dec 2009 17:07:54 -0600Try the formula .It will do what you want.https://community.betfair.com/exchange_games/go/thread/view/94066/23453482/excel-hekp-please?post_id=418845186#418845186Try the formula .It will do what you want.Sun, 27 Dec 2009 17:00:23 -0600thanks guys but may be i did not explain properly, i have the t's in the column and i want the no.s in the next coulmn to be put there by the formula applied to the t column....in other words the colums with no.s is the answer i am looking for..thankhttps://community.betfair.com/exchange_games/go/thread/view/94066/23453482/excel-hekp-please?post_id=418845178#418845178thanks guys but may be i did not explain properly, i have the t's in the column and i want the no.s in the next coulmn to be put there by the formula applied to the t column....in other words the colums with no.s is the answer i am looking for..thankSun, 27 Dec 2009 16:42:43 -0600If the t's appear in column A and the count in column B, then simply enter the following formula into cell B2 and copy it down column B,= if ( a2="t", b1+1,0)Obviously you should start with blank cells in row 1https://community.betfair.com/exchange_games/go/thread/view/94066/23453482/excel-hekp-please?post_id=418845162#418845162If the t's appear in column A and the count in column B, then simply enter the following formula into cell B2 and copy it down column B,= if ( a2="t", b1+1,0)Obviously you should start with blank cells in row 1Sun, 27 Dec 2009 12:59:54 -0600I am trying to achieve the following, count the no. of t's and place the no. in the adjacent cell, resetting after each set of t's when a blank cell is encountered....basically to count the no. of t's between two blank cells...i am just learning excehttps://community.betfair.com/exchange_games/go/thread/view/94066/23453482/excel-hekp-please?post_id=418845154#418845154I am trying to achieve the following, count the no. of t's and place the no. in the adjacent cell, resetting after each set of t's when a blank cell is encountered....basically to count the no. of t's between two blank cells...i am just learning exceSun, 27 Dec 2009 10:04:18 -0600