# Sumproduct with Wild Cards

Crispo Mwangi | 18-Jun-16 | 8 CommentsThe 3 wildcard characters (?*~) used in other excel formulas do not work with sumproduct. However, SUMPRODUCT utilizes other functions (LEFT, RIGHT, FIND and MID) to give you the same results. Using below example showing Cost Codes and Total Cost, ►Find the Sum of the total cost for Sales department if all Sales department cost codes starts with […]