Hello!
I've come up with a solution for summing the values of column B if the corresponding value in column A contains a substring that matches any of the values in a given list of strings, here the named range 'Matbutiker', which requires me to put either 0 or the value in a new column using the following formula:
, populating the entire column for the entire range, A3:A24 and B3:B24, and then summing over that column. In my case I get entire E3:E24 full of irrelevant partial calculations.
What I really want to do is, since I'm only interested in the resulting sum and not the partials, is to put this condition in a SumIf formula to avoid having to spend and hide an entire column for this.
This is what I imagine I would be able to do:
If any of the entries in A3:A24 contains a substring of any of the strings in the named range Matbutiker, sum the corresponding value in B3:B24. Obviously the formula above doesn't work and I think the problem lies within the , which can't handle arrays?
Can I somehow generate an array out of this condition so I can sum over it without explicitly having to do the partial calculations in another column? Please any hints or tips would be appreciated - I've wrestled with this for far too long!
Regards,
Daniel
Bookmarks