how to get formulas run when using filter

I want to know that formulas work when filtering data..?

In m2,

i given formula for calculating sum of all credit values in M2.

but it is showing always same result.

but i want result for filtered data too..

Can anyone help me in this issue.

thanks a lot in advance


find this attached STOCK RECORD SAMPLE.xlsx file

Hi
Use this formula (see SUBTOTAL OPTIONS)

Formula:

Please Login or Register  to view this content.

It is working,

but i have doubt that,

here in formula, number "9" refers to what brother ..?

Hi
Number 9 refers to option SUM
Other numbers refers to other options like 1 - MEAN; 2 - COUNT, ...
To see all options goto a empty cell and begin a formula with =SUBTOTAL( and you will see the options

Thank you buddy ..