Wildcards, SUMIF, number

[TZ Saic]

I need to sum transactions (column C) based on the part of the account number in column B. Example of the account number is 1234330001. Cells with account numbers are set as general. I need to sum all items that have 433 in the account number.

Formula =SUMIF(Transactions!B:B;"*416*";Transactions!C:C) does not work.

Please help.

[Glenn Kennedy]

Hi there & welcome to the Forum. Wildcards don't work on numbers; so use SUMPRODUCT & MID instead.

Given your location - don't forget to use ; instead of , in the formula

[TZ Saic]

Thank you! It works.

[Glenn Kennedy]

Thanks for the Reputation that you have added. It's much appreciated. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.