Excel Forum

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

Got a Question? Ask it Here in the Forum.