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,
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,