SUMPRODUCT

Yes, it’s an Excel function. One I knew about, kind of, but had never needed to use, until today. Luckily, for all of us who were working on this formula, I found this page using Google and it made for an easy to follow example of summing the data in cells that matched mulitple criteria. Who said using the Web at work was unproductive?

Tags: SUMPRODUCT, Excel, Google

Similar Posts

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

To respond on your own website, enter the URL of your response which should contain a link to this post's permalink URL. Your response will then appear (possibly after moderation) on this page. Want to update or remove your response? Update or delete your post and re-enter your post's URL again. (Find out more about Webmentions.)