Get sum of only visible values?

[carura]

I have a table with autofilter enabled

I also have a cell that is supposed to show the sum of values in column C, cell C1

But the things is, the sum formula gets the sum of everything in column C.
I only want the formula to add items when it's visible in the table.
If I want to know the total expenses on bond paper, I select bond paper in column D's filter
Then the expenses will show up with bond paper but I till get the sum of everything in Cell C1.

Help please

 

[shg]

See the SUBTOTAL function.

 

[Innsbruck]

Hey Carura,

You can do that with subtotal function.


=SUBTOTAL(9,C1:C100)

C100 has to be changed to the last cell in column C i.e, the cell just above the formula cell.

I hope it helps

 

[carura]

Thanks Innsbruck and shg !!! ^_^

 

[shg]

You're welcome.

 

[Innsbruck]

You're welcome