Required filtered value

[tanwarrahul1988]

pls help to find value in E9 Cell but the value shows Debit-Credit when i filter the sheet, same i attach the sheet

 

[vletm]

tanwarrahul1988​

How do You have plan to filter something?
Could You use something like this?

 

[tanwarrahul1988]

i am filtering A row and in E9 value shows Dr-Cr

 

[vletm]

tanwarrahul1988​

# How ...? You answered ... what?
# Did You skip my Could ...?

 

[tanwarrahul1988]

tanwarrahul1988​

How do You have plan to filter something?
Could You use something like this?

i am using this but i required sir when i filter A row then in E9 cell value will be shows debit -(minus) credit

 

[vletm]

tanwarrahul1988​

Based Your writings.
please study AGGREGATE-function and use it with Your 9th row.
It would work while filtering.

 

[bosco_yip]

In E9 cell value to show debit -(minus) credit, try

E9, enter formula:

=SUMPRODUCT((F2:F8={"Dr.","Cr."})*E2:E8*{1,-1})

or, if you have newest Excel versions

=SUM((F2:F8={"Dr.","Cr."})*E2:E8*{1,-1})

 

[vletm]

tanwarrahul1988​

Write to cell E9 =D9-C9
... after You've expected/verified results in cells C9 & D9.