Extract non-zero list of values containing formula.

[thebeastslayer]

I have used sumif function to calculate consolidated sum. I want to extract a list with non-zero values.

[ImranBhatti]

in J2 enter this formula and press Ctrl + Shift + Enter and drag down.

=IFERROR(INDEX($A$2:$A$10, MATCH(SMALL(IF(COUNTIF($J$1:J1, $A$2:$A$10)=0, COUNTIF($A$2:$A$10, "<"&$A$2:$A$10), ""), 1), COUNTIF($A$2:$A$10, "<"&$A$2:$A$10), 0)),"")

Enter K2 and press simply Enter and copy down

=SUMIF($A$2:$A$10,J2,$B$2:$B$10)

[Bo_Ry]

Please try at J2

=IFERROR(INDEX($A$2:$A$10,MATCH(1,INDEX(ISERROR(MATCH($A$2:$A$10,J$1:J1,))*(SUMIFS($B$2:$B$10,$A$2:$A$10,$A$2:$A$10)>0),),)),"")

[thebeastslayer]

Formula works but what if i add more entries in row 11 and so on then that should also be taken into consderation

[Bo_Ry]

Try
=IFERROR(INDEX($A$2:$A$9999,MATCH(1,INDEX(ISERROR(MATCH($A$2:$A$9999,J$1:J1,))*(SUMIFS($B$2:$B$9999,$A$2:$A$9999,$A$2:$A$9999)>0),),)),"")