fishbyname
New Member
- Joined
- Nov 11, 2004
- Messages
- 12
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
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