Results 1 to 7 of 7

Thread: Formula To Show The Sum Of Filtered List Using SubTotal

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Oct 2012
    Posts
    31
    Rep Power
    0
    Then what should be values in respective columns..

    Quote Originally Posted by Flupsie View Post
    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

  2. #2
    Member
    Join Date
    Aug 2012
    Posts
    40
    Rep Power
    0
    Quote Originally Posted by in.vaibhav View Post
    Then what should be values in respective columns..
    Thanks for the reply. The filtered value I3 should be 17,061.85 and the total in I2 should be (22,443.66)

Similar Threads

  1. Replies: 3
    Last Post: 04-17-2014, 09:57 PM
  2. A code to show colour in cell from list
    By rodneykaye in forum Excel Help
    Replies: 4
    Last Post: 10-18-2013, 03:56 PM
  3. Excel Sum Formula
    By mfaisalrazzak in forum Excel Help
    Replies: 6
    Last Post: 07-26-2013, 11:42 AM
  4. Did You Know :: Excluding Hidden Cells from SUM (and other) Formulas - SUBTOTAL
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-23-2013, 07:21 PM
  5. Sum Of The Digits In A Cell Using Formula
    By venkat1926 in forum Excel Help
    Replies: 0
    Last Post: 04-30-2013, 07:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •