Formula To Show The Sum Of Filtered List Using SubTotal

I am struggling to get the individual account subtotals to display correctly on sheet "Data"

The concept is that :
If My filter hides the 1st occurrence, then the subtotal should appear on first VISIBLE row
The workbook should always show the TOTAL of the imported data (I2), but if the workbook is filtered, it should also show the filtered total in row 3

Even though the subtotals add up to the correct total when added manually

The value in cell I3 is displaying the correct subtotal value when I do a filter. Not sure what the issue is at your side. Can you clarify with an example?

can you explain further with example..

Thanks for the reply

If All The items are filtered , then the formulas In I2 to L4 gives the correct answer. However, If I de-select a value by clicking on the drop down filter in J5 and de-select for eg R -39505.51 ,
the formulas in I2:L4 returns an incorrect result

Please test and amend formula

Then what should be values in respective columns.. :confused:

Quote:

---

Originally Posted by Flupsie

Thanks for the reply

If All The items are filtered , then the formulas In I2 to L4 gives the correct answer. However, If I de-select a value by clicking on the drop down filter in J5 and de-select for eg R -39505.51 ,
the formulas in I2:L4 returns an incorrect result

Please test and amend formula

---

Quote:

---

Originally Posted by in.vaibhav

Then what should be values in respective columns.. :confused:

---

Thanks for the reply. The filtered value I3 should be 17,061.85 and the total in I2 should be (22,443.66)

Quote:

---

The filtered value I3 should be 17,061.85 and the total in I2 should be (22,443.66)

---

These are exactly the results I get, so I'm not able to reproduce the problem.:(