+ Reply to Thread
Results 1 to 2 of 2

Need formulas to count or sum only cells with specific value in a filtered list

  1. #1
    Registered User
    Join Date
    01-16-2015
    Location
    North Carolina, USA
    MS-Off Ver
    2007
    Posts
    22

    Need formulas to count or sum only cells with specific value in a filtered list

    I have a "summary" worksheet which summarizes some of the key data found in other worksheets within the same workbook. The data in each of the detailed worksheets has the data filtered already. I know how to use the subtotal function to count the number of cells found in data filtered column, but I want to only count the cells in that filtered column that have a value over 30. BTW, changing the data filter is not an option for what I want to show. Attached is the spreadsheet so you can see exactly what I'm trying to accomplish.
    Attached Files Attached Files
    Last edited by JeffW012; 06-06-2017 at 04:10 PM. Reason: add attachment

  2. #2
    Registered User
    Join Date
    06-06-2017
    Location
    United States
    MS-Off Ver
    MS 2016
    Posts
    1

    Re: Need formulas to count or sum only cells with specific value in a filtered list

    For counting how many claims over 30, try this formula entered as an array formula

    =SUM(IF('SHEET_NAME_HERE'!D:D>30,1,0))-2
    then press CTRL + SHIFT + ENTER

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to count specific items in a filtered table
    By pr1nce in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2015, 07:23 PM
  2. [SOLVED] Creating formulas to count cells that fall into specific ranges
    By vinceancona in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-19-2013, 02:51 PM
  3. How to Count the Number of Cells Greater than Zero in a Filtered List?
    By denise001 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-01-2011, 11:33 AM
  4. Replies: 2
    Last Post: 11-16-2007, 10:36 AM
  5. count specific value with filtered data
    By Shawn13 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-28-2006, 07:30 PM
  6. How can I count items in a filtered list?
    By N Harkawat in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 03: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