Results 1 to 11 of 11

CountIf for Each SubTotal

Threaded View

punster CountIf for Each SubTotal 12-01-2020, 11:31 AM
Harribone Re: CountIf for Each SubTotal 12-01-2020, 11:43 AM
Glenn Kennedy Re: CountIf for Each SubTotal 12-01-2020, 12:02 PM
punster Re: CountIf for Each SubTotal 12-01-2020, 12:17 PM
Glenn Kennedy Re: CountIf for Each SubTotal 12-01-2020, 12:27 PM
punster Re: CountIf for Each SubTotal 12-01-2020, 12:33 PM
Glenn Kennedy Re: CountIf for Each SubTotal 12-01-2020, 12:39 PM
Glenn Kennedy Re: CountIf for Each SubTotal 12-01-2020, 12:41 PM
Glenn Kennedy Re: CountIf for Each SubTotal 12-01-2020, 12:45 PM
punster Re: CountIf for Each SubTotal 12-01-2020, 12:57 PM
Glenn Kennedy Re: CountIf for Each SubTotal 12-01-2020, 01:00 PM
  1. #4
    Registered User
    Join Date
    06-27-2014
    Location
    New York
    MS-Off Ver
    2010
    Posts
    9

    Re: CountIf for Each SubTotal

    Have attached a sample spreadsheet. What I would like to be able to do is to ues the subtotal function but in Column D have the subtotal row show the count of the number of rows that have "Match" Needless to say the sheet does other functions and uses vlookup to get to the point of what I am trying to do. Bottom line question - is it possible to use the subtotal function on Column D and have it only count if the cell has the specific value for each subtotal - as I said in the original, it is a rather large spreadsheet and will have over 750 subtotal rows.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Subtotal countif
    By Median in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-20-2018, 08:37 PM
  2. How to do COUNTIF with SUBTOTAL
    By ZOZOZIAD in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-28-2018, 09:02 AM
  3. [SOLVED] Subtotal and Countif
    By Lehany in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-10-2014, 01:53 PM
  4. [SOLVED] =Subtotal(countif,Range); Subtotal and countif in 1 formula [SOLVED]
    By thomas.mapua in forum Excel General
    Replies: 5
    Last Post: 01-06-2012, 11:33 AM
  5. Countif in subtotal
    By coolzero in forum Excel General
    Replies: 1
    Last Post: 05-25-2011, 03:41 PM
  6. If, Countif, Subtotal...?
    By richandjo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-24-2008, 06:44 AM
  7. [SOLVED] > but < subtotal (3,...) or countif
    By PAR in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-22-2006, 05:55 AM

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