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
Bookmarks