ExcelBanter - Sumproduct Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sumproduct Help (https://www.excelbanter.com/excel-worksheet-functions/219416-sumproduct-help.html)

David

Sumproduct Help

Starting with (1) SUMPRODUCT((Rng<"")/COUNTIF(Rng,Rng&""))
I am trying (and failing) to count uniques (always values) greater than a
specified value
ie a combination of SUMPRODUCT(--(Rng=4)) and (1)
Any advice will be most appreciated

Mike H

Sumproduct Help

David

=SUMPRODUCT((A1:A100=4)/COUNTIF(A1:A100,A1:A100&""))

Mike

"David" wrote:

Starting with (1) SUMPRODUCT((Rng<"")/COUNTIF(Rng,Rng&""))
I am trying (and failing) to count uniques (always values) greater than a
specified value
ie a combination of SUMPRODUCT(--(Rng=4)) and (1)
Any advice will be most appreciated

All times are GMT +1. The time now is 02:54 PM.