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. Using SUMPRODUCT to Count with Criteria In… Read More »Using Excel’s SUMPRODUCT with IF Criteria/Conditions
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… Read More »Perform Weighted Average Calculations Using Excel’s SUMPRODUCT Function
Using the FileSytemObject The FileSystemObject (FSO) provides a useful way to access the filing system on your computer and network drives. To use the FSO you first need to create a reference to the Microsoft Scripting Runtime Library. In the VBE click Tools | References. Check the option Microsoft Scripting Runtime and click OK. You… Read More »Excel VBA File Management Using The FileSytemObject