+ Reply to Thread
Results 1 to 2 of 2

Subtotal on SumIf

  1. #1
    Steven
    Guest

    Subtotal on SumIf

    Can you use subtotal on a sumif or maybe some other method so when data is
    filtered it calculates correctly. I have tried many things but cannot make
    it work.



  2. #2
    Peo Sjoblom
    Guest

    RE: Subtotal on SumIf

    here is a method

    =SUMPRODUCT(--($A$2:$A$100>5),--(SUBTOTAL(3,OFFSET($A$2,ROW($A$2:$A$100)-MIN(ROW($A$2:$A$100)),,))),$A$2:$A$100)

    this will sum all visible entries in A2:A100 that are greater than 5
    where for instance column B could have been filtered



    Regards,

    Peo Sjoblom

    "Steven" wrote:

    > Can you use subtotal on a sumif or maybe some other method so when data is
    > filtered it calculates correctly. I have tried many things but cannot make
    > it work.
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1