Change current formula to exlude row if not savings is associated with it.

=IF(COUNTIFS($L$4:$L$13,$L10,$K$4:$K$13,">0")>0,"Savings","")

The current formula Captures all the rows if there is a savings. I only want it to caputre the first line that includes the search term, the Base item (column I), and the savings potential (+ number in column K). I don't want it to include the rows that have no savings.

If you look at the document. I do not want it to say savings for row 13 because there is no savings assiocated with the line.

Please Login or Register  to view this content.

How would that translate to a code?

Actually, that only works if K > 0. That is not what I need. Refer to attached sheet.

I think I got the formula. =IF(SUMIFS($K$4:$K$20001,$L$4:$L$20001,$L4,$K$4:$K$20001,">0")>0,"Savings","").