SUM of filtered results?

  • Thread starter Thread starter Ascesis
  • Start date Start date
A

Ascesis

On my worksheet - among other things - is a list of people, associate
with locations, and costs associated with these people.

The final row addresses the total cost of all these people at al
locations.

At the moment, I am using a different worksheet for every location, s
that I can see a total cost for every location. I also have an 'All
worksheet, so I can see the total cost of all the folks.

I just want to reduce the number of worksheets (to one!) I have, so
don't need to enter the same data twice.

----------

Is there some way to display the total cost of people at a certai
location, after the worksheet has been filtered by location?

In other words, when I filter the location column for 'London', a tota
cost for all people in 'London' is displayed...somewhere.




Hopefully, this is a novice request so...thanks in advance
 
Take a look at the =subtotal() function.

It will ignore the rows that were hidden by the autofilter.

I like to put these subtotal formulas in row 1, headers in row 2 and data in
rows 3 to xxx.

Then they're always visible.
 
Ok, so could you explain the =subtotal() function? That is, what th
parts: 'function_num, ref1...' are.

Apparently, I can't just enter the function and then the relevan
('cost') range within the brackets like with SUM (the extent of m
knowledge) :cool:


Yes, I am a total noob but I don't revel in it
 
Back
Top