New Posts For Thread: EXCEL formulahttps://community.betfair.com/general_betting/go/thread/view/94082/30350871/excel-formulaNeed a one cell formula for adding up tennis games.Instead of 6-1, 4-6, 6-4the date is entered into three cells like:6.1 4.6 6.4Need a one cell formula that takes those numbers and come to the total (in this example, 27)Cheers.No trouble.https://community.betfair.com/general_betting/go/thread/view/94082/30350871/excel-formula?post_id=541505103#541505103No trouble.Thu, 18 Sep 2014 08:22:44 -0500Cheers and it works. Appreciated.I'm a 'visual' person so having 6.2 6.4 versus 6 2 6 4 works for me. The cells with the decimal are pattern coded, as well.https://community.betfair.com/general_betting/go/thread/view/94082/30350871/excel-formula?post_id=541503277#541503277Cheers and it works. Appreciated.I'm a 'visual' person so having 6.2 6.4 versus 6 2 6 4 works for me. The cells with the decimal are pattern coded, as well.Thu, 18 Sep 2014 05:59:48 -0500That's making life hard for yourself; what does conctenating the data into 3 cells give you that entering it in six cells as 6,1,4,6,6,4 doesn't? Easy enough to stick the pair of scores for each player together if you need them in that format at anyhttps://community.betfair.com/general_betting/go/thread/view/94082/30350871/excel-formula?post_id=541502733#541502733That's making life hard for yourself; what does conctenating the data into 3 cells give you that entering it in six cells as 6,1,4,6,6,4 doesn't? Easy enough to stick the pair of scores for each player together if you need them in that format at anyThu, 18 Sep 2014 04:58:49 -0500Need a one cell formula for adding up tennis games.Instead of 6-1, 4-6, 6-4the date is entered into three cells like:6.1 4.6 6.4Need a one cell formula that takes those numbers and come to the total (in this example, 27)Cheers.https://community.betfair.com/general_betting/go/thread/view/94082/30350871/excel-formula?post_id=541502627#541502627Need a one cell formula for adding up tennis games.Instead of 6-1, 4-6, 6-4the date is entered into three cells like:6.1 4.6 6.4Need a one cell formula that takes those numbers and come to the total (in this example, 27)Cheers.Thu, 18 Sep 2014 04:44:45 -0500