| 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 | |||
Hybrid Mode
