Excel Magic Trick 851: Formula To Sum Unique Values In Column




About this tutorial:

Video duration: 12:4
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn how to:
1. Sum Unique Values In Column with no blanks using a formula that contains the SUMPRODUCT and FREQUENCY functions
2. Sum Unique Values In Column when there are blanks using a formula that contains the SUM, IF, FREQUENCY, MATCH and ROW functions

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads