| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Unique sumproduct with criteria!
Hi,
I have a unique count using a sumproduct formula like this... =sumproduct((D2:D100<")/(countif(D2:D100,D2:D100)+(D2:D100="") which seems to work ok. The problem is I then want to add another criteria saying only count uniques where the date in column F = "01/01/05". Nothing I've tried seems to work. Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using COUNTIF with 2 criteria - SUMPRODUCT? | Excel Worksheet Functions | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| Count Unique Names in list w/ Additional Criteria? | Excel Worksheet Functions | |||
| sumproduct using multiple criteria | Excel Worksheet Functions | |||
| Sumproduct - multiple criteria in Column A | Excel Worksheet Functions | |||
Threaded Mode
