PDA

View Full Version : Excel help please


foxwood
7th July 2011, 03:57 PM
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

gunny72
7th July 2011, 04:11 PM
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.

foxwood
8th July 2011, 04:08 PM
Terrific Gunny72, that's good thinking. Many thanks,
Cheers
Ron