Closed Thread
Results 1 to 3 of 3

Need updated Sum when data is filtered

  1. #1
    Registered User
    Join Date
    01-10-2020
    Location
    Portland
    MS-Off Ver
    365
    Posts
    4

    Need updated Sum when data is filtered

    I'm trying to write my formula to update my totals when I apply a filter to the column.

    Currently I'm using COUNTIF($B$17:$B$1000,"1")

    "1" in this instance is a name and NOT intended to be a value. I need the Sum to land in B3.

    I've been trying to use =SUMPRODUCT with no success. Unfortunately, this is a new formula for me.

    =SUMPRODUCT(SUBTOTAL(3,OFFSET($B$17:$B$1000,ROW($B$17:$B$1000)-ROW($B$17),0,1)),--($B$17:$B$1000="1"))

    This formula was found on another forum and I attempted to customize it. When used it returns a total of "0"


    Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-10-2020
    Location
    Portland
    MS-Off Ver
    365
    Posts
    4

    Re: Need updated Sum when data is filtered

    I'm sorry I think I posted this in the wrong place. I can't figure out how to delete it. I reposted it to the correct location.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,546

    Re: Need updated Sum when data is filtered

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...-to-table.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy filtered data into filtered range in a separate sheet
    By vikas.trades25 in forum Excel General
    Replies: 1
    Last Post: 02-07-2019, 04:04 AM
  2. Pasting filtered data back into filtered data
    By pigment01 in forum Excel General
    Replies: 1
    Last Post: 10-18-2017, 11:54 AM
  3. Cell reference to filtered data auto update as Filtered result changes
    By Irajoo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-22-2017, 02:17 AM
  4. Replies: 2
    Last Post: 11-28-2013, 09:00 AM
  5. Replies: 3
    Last Post: 11-04-2013, 07:50 PM
  6. Replies: 4
    Last Post: 09-04-2012, 06:09 AM
  7. Rev. Auto Updated when sheet is updated and or entire book
    By frankee_gee in forum Excel General
    Replies: 1
    Last Post: 04-07-2008, 05:05 PM

Tags for this Thread

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