In partnership with Experts Exchange.
Excel’s Sumproduct function lets you do two calculations at once and reduces the number of columns you need in a worksheet, so your sheets can be less cluttered and with less work. As the name sounds, Sumproduct adds and multiplies two cell ranges in one shot. This function works in all editions of Excel and Google Sheets.