I have a table with columns A,B,C,D,E,F,G. Column A-F are categories and are sorted first on A, 2nd on B and so on through column F. G is a price.
I want to count and total column G for rows that match on all columns A-F.
So for a table that contains columns like Country State County City Street House Price(actual column names are different and make little sense to someone outside the company),
how do I count the number of houses on a street and subtotal the price? The problem is that you could have two cities with the same street number. These two cities could be adjacent in the sorted rows. So I can't just count and subtotal when the street changes since sometimes the streets will be the same while the cities are different.