Hello,
I am new here. I am trying to Return top 10 Items based on the sum of associated values, but not include the sum of blank cells.. For example: Item A has a total of 345 and Item D has a total of 312 and the blank cells have a total of 1071. The formula I am using goes as such {=IFERROR(INDEX(B$1:B$9,MATCH(1,(COUNTIF(G$1:G2,B$1:B$9)=0)*(LARGE(SUMIF(B$1:B$9,B$1:B$9,D$1:D$9)*(MATCH(B$1:B$9,B$1:B$9,0)=ROW(B$1:B$9)-ROW(B$1)+1),F3)=SUMIF(B$1:B$9,B$1:B$9,D$1:D$9)),0)),"")}. It works to put the items in order based off of summed values but it still includes the blanks. For example: A should be the top and D should be next, but the blank cells lead the way. I should mention that the Item column has formulas in it more specifically the "" in each formula. I am positive that is what is giving me problems.
Please show me what I need to do to not include blank item cells.
I have attached the document.
Bookmarks