| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Elementary SUMPRODUCT Question
I have used this formula to count unique names in a list (from another Banter thread from 2010):
=SUMPRODUCT((B1:B20<"")/COUNTIF(B1:B20,B1:B10&"")) I do not know how this works, especially the / operator. Would someone be willing to explain how this formula works? Thanks a lot |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function using autofill and auto select - elementary arithmetic | Excel Discussion (Misc queries) | |||
| Elementary(?) GetChartElement Question | Charts and Charting in Excel | |||
| Elementary question | Excel Discussion (Misc queries) | |||
| Im sure this question is elementary... | Excel Worksheet Functions | |||
| SumProduct question | Excel Discussion (Misc queries) | |||
Threaded Mode
