Remove Duplicates
Evan Paulus
Learn how to use the Remove Duplicates feature of Excel to produce a quick summary table.
Read MoreTips for Excel Users
Filtering by Tag: SUMIF
Relative and Absolute Cell References
Evan Paulus
A quick guide to understanding those dollar signs ($) in your formulas and how to use them to make your Excel experience simpler.
Read MoreSUMIF 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 More