Category: Tutorial

SUMPRODUCT with Criteria This tutorial assumes you understand the basic functionality of SUMPRODUCT – in that it finds the product of corresponding values in each column/row/array and then sums those calculation results. We will focus on the opportunities to count and sum records based on criteria using SUMPRODUCT.

VIDEO TRAINING - LEARN AT YOUR OWN PACE

DEEP DIVE INTO LOOKUP FUNCTIONS - XLOOKUP, VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, IFERROR, ISNA, IFNA, LEFT, RIGHT, MID, FIND, SEARCH, LEN, SUBSTITUTE, REPLACE, TRIM, CLEAN & INDIRECT.  Click here to enrol

THE MS ACCESS FOR BEGINNERS' COURSE - Click here to enrol

FREE STUFF
70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf 

Weighted Average Calculations A normal average calculation sums values and then divides by the number of values.  This basic average calculation works fine unless you need to give a different weight to each value.  For example, our students take 5 exams a year and we need to calculate their overall percentage at the end of…