COUNTIFS - Summary of all data
Results 1 to 3 of 3

Thread: COUNTIFS - Summary of all data
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2018
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default COUNTIFS - Summary of all data

    When trying to count a particular group (Group 1 or Group 2) I am getting the correct data (1)
    How to get the overall data (2) using COUNTIFS

    Group Status
    Group 1 Not Started
    Group 2 Not Started

    =COUNTIFS($B:$B,"Not Started",$A:$A,"Group 1")

  2. #2
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    5,146
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    2 Thread(s)

    Default Re: COUNTIFS - Summary of all data

    Hi,

    Add additional criteria within {} as needed:

    ABCD
    1GroupStatus3
    2Group 1Not Started
    3Group 3Not Started
    4Group 2Not Started
    5Group 1Not Started

    Sheet632



    Worksheet Formulas
    CellFormula
    D1=SUM(COUNTIFS($B:$B,"Not Started",$A:$A,{"Group 1","Group 2"}))

    Last edited by jtakw; Mar 8th, 2019 at 03:58 PM.

  3. #3
    New Member
    Join Date
    Mar 2018
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: COUNTIFS - Summary of all data

    What if i need the count for a particular group if selected. If not, then the count for all the groups ?

    Quote Originally Posted by jtakw View Post
    Hi,

    Add additional criteria within {} as needed:

    A B C D
    1 Group Status 3
    2 Group 1 Not Started
    3 Group 3 Not Started
    4 Group 2 Not Started
    5 Group 1 Not Started
    Sheet632

    Worksheet Formulas
    Cell Formula
    D1 =SUM(COUNTIFS($B:$B,"Not Started",$A:$A,{"Group 1","Group 2"}))

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •