SUMPRODUCT
Evan Paulus
SUMPRODUCT is a useful function when you have an inventory of items with associated costs and you're interested in evaluating the total cost of the list.
Read MoreTips for Excel Users
Filtering by Tag: Excel
SUMIF and SUMIFS
Evan Paulus
At the core of Excel is the ability to perform basic mathematical operations on one of more values. The SUMIF and SUMIFS functions allow you to extend that ability by adding only when certain conditions are met.
Read MoreVLOOKUP and INDEX/MATCH
Evan Paulus
Becoming an expert in VLOOKUP and the INDEX/MATCH function combo will help you navigate your way through any Excel table.
Read More