Sumproduct with Wild Cards

Crispo Mwangi | 18-Jun-16 | 4 Comments

The 3 wildcard characters (?*~) used in other excel formulas do not work with sumproduct. All the same SUMPRODUCT utilizes other functions (LEFT, RIGHT, FIND and MID) to give you the same results. Suppose the following is yearly financial transactions  showing  Cost Codes and Total Cost ►Find the Sum of the total cost for Sales department if […]