If(count()) question

[rockhopper]

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!

 

[Sal Paradise]

Is Races multiple rows? Or is it just 1 row? And if it's multiple rows, you want the 7 largest column sums, correct?

 

[Sal Paradise]

Is there some reason this won't work instead?

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Data 1	Data 2	Data 3	Data 4	Data 5	Data 6	Data 7	Data 8	Data 9	Data 10	Data 11	Data 12	Data 13	Data 14	Data 15	Data 16	Data 17	Data 18	Data 19	Data 20
2	471	220		195		28	837			186	848	735	395			547	618		124	883
3	175	888		300		820	131			569	10	986	887			33	983		855	758
4	4	988		572		831	237			980	579	953	564			660	763		551	515
5	78	99		951		522	184			831	765	74	729			195	177		889	234
6	249	515		953		524	82			773	215	688	204			368	559		497	705
7	928	568		729		904	876			465	647	31	49			730	239		617	965
8	395	162		161		184	775			587	72	74	175			381	162		123	869
9	583	946		206		657	269			579	586	120	260			516	473		872	59
10	786	402		170		550	968			353	885	976	905			108	855		212	910
11
12
13	Sum:	6846
14	1	988
15	2	986
16	3	983
17	4	980
18	5	976
19	6	968
20	7	965
Sheet1

 

[rockhopper]

After fighting this for a couple hours, I fought it some more. I swear my logic was correct, but it wasn't working. Anyways, thanks. Here's what ended up working for me, my >6 was placed count(races >6):

=IF(COUNT(Races) >6, SUM(LARGE(Races, {1,2,3,4,5,6,7}) ), SUM(Races))

 

[Sal Paradise]

What I don't get is why you even use the IF. You want the 7 biggest values. Empty cells will be zeroes. Why not just make the formula:
=SUM(LARGE(Races, {1,2,3,4,5,6,7}))

 

[rockhopper]

When I tried to sum the 7 largest values when there was less the 7, I was getting an error, so I had to create case for a racer who had less then 7 races.

 

[shemayisroel]

Ok so has the problem been resolved?

 

[rockhopper]

Ok so has the problem been resolved?

Yes, thank you.