Using filters

[eqbal]

Hi,

I have 3 columns in my sheet. A:A goes for DISCRIPTION; B:B for DEBIT and C:C for CREDIT. Cell D1 is for the balance with the following formula: D1= SUM(B:B) – SUM(C:C).

I use AUTO FILTERS to see a single transaction. I want the D1 to calculate only the data which is filtered while now it uses all the data in B:B and C:C for the results. How can I exclude the filtered data from being calculated in the formula?

Thank you for your advice in advance.

Best regards,

 

[Juan Pablo González]

Try using the SUBTOTALS function instead. Replace

=SUM(B:B)

with

=SUBTOTALS(9,B:B)

 

[eqbal]

Dear Juan,
THANK YOU. U know I was so frustrated and just felt so sluggish to use the help. If u were here I would have given u a big hug.
That was a very nice and simple advice. I'm glad to have participated in this forum.

Kind regards