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?
Follow these topics: Uncategorized