I have a problem similar to the one in this thread, I'd like to point to the text contents of a cell to use as criteria in my Sumifs function. My formula currently looks like this:
=SUMIFS(Data!B:B,Data!A:A,"*CIP-168*")
I want to pick up all cells in my criteria range with the text "CIP-168" in them, but I don't want to have to type it in my Sumifs formula, I want to reference a cell with the text "CIP-168" in it. I appreciate any help, thank you!
Bookmarks