Hi All, how do i turn: =SUMIFS($C$4:$C$18,$A$4:$A$18,"*"&F6&"*") - into a function that helps me to identify/highlight/mark the values that are being summed up. F6 = equals two letters - AT. Basically sumifs all the values that have the letter 'AT' in them. The formula works fine but I don't know which cells are being added. If I can identify the values using a helper column (or something) then I can filter them and see what's included in the total. I would also like to know how to just identify the (partial) values in cells without using SUMIFS. Many thanks in advance.