Snasui Excel Forum

Hi dear,

I need your assistance how to sum values among errors base on criterias . output also provided in an attachment


Thanks

Please try;

H2

=SUM(SUMIFS(B$2:B$21,B$2:B$21,{"<0",">0"},$A$2:$A$21,$G2))

Enter copy to the right then down.

Thank you