how to get total sum by filters

[dmedina]

I have an expense worksheet with filters, at the bottom of the sheet I have a
formula calculating the total expenses. When I filter it by categories, ie:
groceries, how do I get the total just for groceries? Is there a formula to
calculate the totals everytime I filter the category list? Right now when I
filter it by category to see how much I spent on groceries I only get the
total for everything.

 

[T. Valko]

Look in Excel help for the SUBTOTAL function.

There are many criteria that can used with this function so look in help to
see which is right for your situation.

 

[Sandy Mann]

SUBTOTAL() will ignore any Rows hidden by filtering.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[dmedina]

THANK YOU, but I couldn't figure out the formula
=SUBTOTAL(B2:B33)
THAT DIDN'T WORK, I MUST NOT HAVE IT RIGHT.

 

[dmedina]

NEVER MIND, I GOT IT, I JUST HAD TO ENTER A 9 IN FRONT OF THE RANGE. THANK YOU.

 

[Sandy Mann]

That's the best way to learn.<g>

Glad that you got it worked out.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[happyhenry]

can i give a huge thanks to both biff and demedina. this does indeed work and
i've been wanting to wrok out how to do this for ages.

i only wish i understood the formula!

Henry