Results 1 to 11 of 11

Calculating 3 from 5 cells

Threaded View

  1. #1
    Registered User
    Join Date
    05-13-2012
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    7

    Calculating 3 from 5 cells

    Hi All
    I need helping with some road running race results i'm doing. We are doing 5 races with the winner being the runners with the 3 lowest points from 5 races.so I want to work out the value of 3 from 5 cells eg A2, C2, D2, G2 H2 and have in cell J2 the total score from the 3 races. I've tried using the formula "small" but I'm going wrong.
    Please help!
    Thanks
    Last edited by bazzabarry; 05-13-2012 at 07:13 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1