adding top 6 results... but still adding if there are less then 6 entries

I need to add the top 6 results from a series of results but the problem I am having is when there are less then 6 entries it won't add until there are at least 6

this is the formula I am using =SUM(LARGE(C5:N5,{1,2,3,4,5,6}))

it works great if I have 6 or more entries but I need it to add the entries if there are less then 6 as well and then if over 6 it needs to add the top 6 value wise

Instead of blanks can you use a '0' zero?

Try this

=SUMPRODUCT(LARGE(C5:N5,ROW(INDIRECT("1:"&MIN(6,COUNT(C5:N5))))))

Hi
Try this

Formula:

Please Login or Register  to view this content.