New Posts For Thread: excel helphttps://community.betfair.com/general_betting/go/thread/view/94082/26130537/excel-helpThanks in advance.Column B contains names. Column E contains a corresponding number.I can use countifs to determine how many times a name occurs, but I'd also like to tot up the corresponding value in Column E each time the specified name occurs in Coh!! just one suggestion...use the search uploads feature on you tubehttps://community.betfair.com/general_betting/go/thread/view/94082/26130537/excel-help?post_id=471620577#471620577oh!! just one suggestion...use the search uploads feature on you tubeMon, 25 Oct 2010 14:21:10 -0500http://www.youtube.com/user/ExcelIsFun"Over 1200 Excel How To Videos. This site is intended to show you many Excel Efficiency Tricks so you can work faster, you can help others at work and you can save enough time to have extra vacation!"i really likhttps://community.betfair.com/general_betting/go/thread/view/94082/26130537/excel-help?post_id=471620189#471620189http://www.youtube.com/user/ExcelIsFun"Over 1200 Excel How To Videos. This site is intended to show you many Excel Efficiency Tricks so you can work faster, you can help others at work and you can save enough time to have extra vacation!"i really likMon, 25 Oct 2010 14:18:10 -0500Cheers.There are a lot of commands i've never used in Excel, but on my way home it occured to me that there was probably a Sumifs command.For speed i'll probably go for the Sumifs and look at the Pivot Table when I have more time.https://community.betfair.com/general_betting/go/thread/view/94082/26130537/excel-help?post_id=471613997#471613997Cheers.There are a lot of commands i've never used in Excel, but on my way home it occured to me that there was probably a Sumifs command.For speed i'll probably go for the Sumifs and look at the Pivot Table when I have more time.Mon, 25 Oct 2010 13:28:31 -0500The problem with sumifs in this situation is you end up with a lot of random numbers and you still need to find the last occurrence of the required value in column B to get the final total. I am ofcourse assuming the problem to be solved is a simplehttps://community.betfair.com/general_betting/go/thread/view/94082/26130537/excel-help?post_id=471603805#471603805The problem with sumifs in this situation is you end up with a lot of random numbers and you still need to find the last occurrence of the required value in column B to get the final total. I am ofcourse assuming the problem to be solved is a simpleMon, 25 Oct 2010 11:56:45 -0500Sorry got it the wrong way round=SUMIFS(E$1:E1,B$1:B1,B1)I really should test first!https://community.betfair.com/general_betting/go/thread/view/94082/26130537/excel-help?post_id=471600697#471600697Sorry got it the wrong way round=SUMIFS(E$1:E1,B$1:B1,B1)I really should test first!Mon, 25 Oct 2010 11:30:40 -0500A pivot table is neater.https://community.betfair.com/general_betting/go/thread/view/94082/26130537/excel-help?post_id=471599981#471599981A pivot table is neater.Mon, 25 Oct 2010 11:25:03 -0500Copy and paste =SUMIFS(B$1:B1,E$1:E1,B1)And fill downhttps://community.betfair.com/general_betting/go/thread/view/94082/26130537/excel-help?post_id=471599717#471599717Copy and paste =SUMIFS(B$1:B1,E$1:E1,B1)And fill downMon, 25 Oct 2010 11:23:11 -0500Sounds as though a simple sumif would work.As an example: =SUMIF(B5:B50,"Name1",E5:E50)https://community.betfair.com/general_betting/go/thread/view/94082/26130537/excel-help?post_id=471599521#471599521Sounds as though a simple sumif would work.As an example: =SUMIF(B5:B50,"Name1",E5:E50)Mon, 25 Oct 2010 11:21:33 -0500Thanks in advance.Column B contains names. Column E contains a corresponding number.I can use countifs to determine how many times a name occurs, but I'd also like to tot up the corresponding value in Column E each time the specified name occurs in Chttps://community.betfair.com/general_betting/go/thread/view/94082/26130537/excel-help?post_id=471597649#471597649Thanks in advance.Column B contains names. Column E contains a corresponding number.I can use countifs to determine how many times a name occurs, but I'd also like to tot up the corresponding value in Column E each time the specified name occurs in CMon, 25 Oct 2010 11:04:57 -0500