|
Featured Tutorial
Featured Macro
YTLE#56: Excel Count Unique Values Greater Than $30
See SUMPRODUCT and COUNTIF together in one amazing Array Formula from Aladin at the Mr Excel (mrexcel) Message Board. See the amazing logic of the count unique records formula that uses division and the fact that 1/3 + 1/3 + 1/3 = 1. See how to use an Array Formula and the COUNTIF function to count unique records that are greater than $30.
Count with multiple conditions criteria. Count Unique Values.
count unique records
Count Unique Records with Formulas / Formula
Count with multiple conditions criteria. Count Unique Values.
count unique records
Count Unique Records with Formulas / Formula