Between the Sheets — Excel podcast episode 49: Excel’s Sumproduct Function

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.

Share:

Facebook
Twitter
Pinterest
LinkedIn
On Key

Related Posts

Get in touch