Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
sumproduct | Excel Worksheet Functions | |||
Sumproduct? | Excel Worksheet Functions |