I'm trying to analyse data in a spreadsheet by whether or not a cell contains a string of characters.
I have this working:
=SUMIF(B7:B43, "*XXXX*", L7:L43)
This works, so if the cell contains XXXX it sums the column. What I want to do is write something like this:
=SUMIF(B7:B43, "*A4*", L7:L43)
SO instead of hardcoding in the string I am looking for (XXXX) it can search if it contains the text I type in A4.
Cheers for any help!
I have this working:
=SUMIF(B7:B43, "*XXXX*", L7:L43)
This works, so if the cell contains XXXX it sums the column. What I want to do is write something like this:
=SUMIF(B7:B43, "*A4*", L7:L43)
SO instead of hardcoding in the string I am looking for (XXXX) it can search if it contains the text I type in A4.
Cheers for any help!