rockhopper
New Member
- Joined
- Mar 26, 2009
- Messages
- 4
I'm trying to add the top seven values from 20 columns of numbers (represented by "Races", but all columns may not have values in them. When <7 columns have numbers, sum just all of them. The function I've written is below, but is now working:
=IF(COUNT(Races >6), SUM(LARGE(Races, 1), LARGE(Races, 2), LARGE(Races, 3), LARGE(Races, 4), LARGE(Races, 5), LARGE(Races, 6), LARGE(Races, 7) ), SUM(Races))
Please Help!
=IF(COUNT(Races >6), SUM(LARGE(Races, 1), LARGE(Races, 2), LARGE(Races, 3), LARGE(Races, 4), LARGE(Races, 5), LARGE(Races, 6), LARGE(Races, 7) ), SUM(Races))
Please Help!