| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtotal only unique in filtered list
I have a spreadsheet that has for example two columns (filters are on this
data) a b 1 in 1 in 2 out 2 out 3 in 3 in I have written the formula =SUMPRODUCT((SUBTOTAL(3,OFFSET($B$1,ROW($B$2:$B$8)-ROW($B$1),,1))*($B$2:$B$8="IN"))) However, when I filter to 1 it says two but I want it to say 1 because I want it to count unique only. can someone please help me. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formulas - Unique List from List with Duplicates | Excel Discussion (Misc queries) | |||
| Subtotals in a list | Excel Discussion (Misc queries) | |||
| list unique values in a column | Excel Worksheet Functions | |||
| How do I paste data into filtered list in Excel? | Excel Discussion (Misc queries) | |||
| Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
Threaded Mode
