+ Reply to Thread
Results 1 to 11 of 11

CountIf for Each SubTotal

Hybrid 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. #1
    Valued Forum Contributor Harribone's Avatar
    Join Date
    02-24-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2019/365
    Posts
    570

    Re: CountIf for Each SubTotal

    =COUNTIFS(G:G,"A") would give you the number of times 'A' is listed in column G.
    Within a specific sub group in that column would require an extra criteria. You haven't stated what determines the subgroups though.

    So if we assume your groups are determing by column F and there are three groups listed in this column (grp1,grp2,grp3) then you can count the number of A's in grp1 by altering the formula to:

    =COUNTIFS(G:G,"A",F:F,"grp1")


    If this doesn't make sense or provide the solution you are after please provide a small sample file with non sensitive data so that we can better understand your requirements.
    Last edited by Harribone; 12-01-2020 at 01:41 PM.

+ 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. [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