+ Reply to Thread
Results 1 to 5 of 5

sum filtered data

  1. #1
    Forum Contributor
    Join Date
    06-20-2007
    Location
    Buckeye, AZ
    MS-Off Ver
    365
    Posts
    262

    sum filtered data

    Hi All,
    In the attached wooksheet, I have a variety of calculations in C6:N10. I wrote these functions before adding a filter. How can I get these functions to reflect only filtered data?
    Thank you for any suggestions!
    Sick
    Attached Files Attached Files
    Last edited by sick stigma; 05-13-2012 at 05:46 PM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: sum filtered data

    See the SUBTOTAL function.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    06-20-2007
    Location
    Buckeye, AZ
    MS-Off Ver
    365
    Posts
    262

    Re: sum filtered data

    thanks! That took care if most of them. How do you nest SUBTOTAL with IF?
    i.e. =SUBTOTAL(109,IF(B12:B112,"=GRANITE")*(G12:G112))
    Suggestions?

  4. #4
    Forum Guru
    Join Date
    05-24-2011
    Location
    Kuwait
    MS-Off Ver
    Office 365
    Posts
    2,200

    Re: sum filtered data

    See the attached.
    Attached Files Attached Files
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  5. #5
    Forum Contributor
    Join Date
    06-20-2007
    Location
    Buckeye, AZ
    MS-Off Ver
    365
    Posts
    262

    Re: sum filtered data

    Wow! I glad you didn't try to explain it! I'll try to soak it up for next time.
    Thanks!!

+ 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