Introduction to SUMPRODUCT: In today’s post we will review some of the use of SUMPRODUCT function. The SUMPRODUCT function is amongst one of the favorites functions for Data Analysis – Particularly when you want to answer exploratory question like “how many”, “how frequent”, finding sum and averages against criteria’s.  So we will start with a brief introduction of the … [Read more...]