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.