When I subtotal in Excel how can I count the number of subtotals?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I subtotal my current balance on address and then I want to count how many
distinct addresses there are
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional SUBTOTAL in XL210 Table 7
description of count in subtotal 1
subtotal within subtotal 5
Subtotal placement issue 2
Getting Text data using the Data - Subtotal feature 1
How can I automatically print subtotal on last row of every page? 3
Subtotal To Include Item Description On Subtotal Line 2
Pivot Table Formula Problem 1

Back
Top