Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 7th July 2011, 03:57 PM
foxwood foxwood is offline
Member
 
Join Date: Jan 2005
Posts: 64
Default Excel help please

Good afternoon all,
I wonder if one of our Excel wizards would be kind enough to help me out here? I'm looking at using the best two of the last three beaten margins of each horse in a race and I want to add them together automatically.
That is, put sum of the contents of the lowest two of three cells in a row into a fourth cell in the same row.

Is this possible? If so how?
I'd appreciate any assistance,
Ron

Last edited by foxwood : 7th July 2011 at 03:58 PM. Reason: clarification
Reply With Quote
  #2  
Old 7th July 2011, 04:11 PM
gunny72 gunny72 is offline
Banned
 
Join Date: Jan 1970
Posts: 147
Default

Have the three margins in three columns, and use the SUM and MAX functions, eg, SUM(A1:C1)-MAX(A1:C1) . This adds all three margins and subtracts the largest leaving the sum of the smaller two, which is what you want.
Reply With Quote
  #3  
Old 8th July 2011, 04:08 PM
foxwood foxwood is offline
Member
 
Join Date: Jan 2005
Posts: 64
Thumbs up

Terrific Gunny72, that's good thinking. Many thanks,
Cheers
Ron
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 08:17 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655