Good Day All,
I did a sum if formula with partial matching for a list of Shipment IDs and its costs. It returns the total cost of all the shipment IDs that match. Now I am trying to highlight or identify in any way those figures that have been used to get the results of the formula. This is to ensure that all shipments are accounted for and those that have not can be found.
This is my formula used:
=SUMIF($A$2:$A$12,"*"&A15&"*", $B$2:$B$12)
Any help would be greatly appreciated.
Thank you,
Teri
Bookmarks