(SOLVED) Use SUMIF function without hardcoding the reference cell

Hi Gurus,

I am using a SUMIF (my formula looks like this SUMIF(F:F,"*A001*",G:G)) function, with "*A00x*" as criteria to sum up any figures that contains A00x in the cell.

My table looks like this:
Excel Queries.JPG

My actual situation has a lot of code, thus it is not feasible for me to hardcode each criteria in the function line by line.
Is there any other way i can link the cell (eg. B3) into the formula reference (eg. "*A001*"), instead of hard coding them line by line?

Thanks in advance!

like this?

Formula:

Please Login or Register  to view this content.

Not a problem, glad to help

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.