| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
When I subtotal in Excel how can I count the number of subtotals?
I subtotal my current balance on address and then I want to count how many
distinct addresses there are |
|
#2
|
|||
|
|||
|
If you total for every change in address then each distinct address would be
the same as each Total? So =SUMPRODUCT(--(ISNUMBER(FIND("Total",A1:A300))))-1 the minus 1 at the end is for the gran total that shoudn't be counted, or just copy all the addresses somewhere else and use a formula on thos addresses =SUM(1/COUNTIF(A2:A300,A2:A300)) entered with ctrl + shift & enter Regards, Peo Sjoblom "Karen S." wrote: I subtotal my current balance on address and then I want to count how many distinct addresses there are |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count dates in excel | Excel Discussion (Misc queries) | |||
| How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
| SUBTOTAL and then count with criteria | Excel Worksheet Functions | |||
| Why is the subtotal function in excel 2003 very slow compared to . | Excel Worksheet Functions | |||
| Excel Count Formula | Excel Worksheet Functions | |||
Linear Mode
