Count top 10 values

[fishbyname]

Hi,

I have a forumula which counts the top 10 values across a row.

{=SUM(LARGE($E2:$V2,{1,2,3,4,5,6,7,8,9,10}))}

The problem is that if there aren't 10 values in a particular row it gives a #NUM error.

Is there some way i can modify this forumla so that if there are less than 10 values it will sum them.

I've tried a few things but just keep getting stuck, any help would be most appreciated.

thanks

G

 

[Domenic]

Try...

=IF(COUNT($E2:$V2)>10,SUM(LARGE($E2:$V2,{1,2,3,4,5,6,7,8,9,10})),SUM($E2:$V2))

Hope this helps!

xl-central.com

 

[fishbyname]

that's great, so simple when you see it

cheers

G