
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
Bookmarks