I have two columns: A containing Tags, B containing values. What I want is to sum all values where the tag contains some substring “MySubStr”. The following expression works for this purpose:
=SUMIF(A1:A10;"=MySubStr.*";B1:B10)
I would like to not hardcode “MySubStr” but to pass it from a different cell, let’s say from C4. What I’m looking for is something like the follwoing but I cannot quite figure out the syntax:
=SUMIF(A1:A10;"=" & C4 & ".*";B1:B10)