COUNTIFS - Summary of all data

[mystique07]

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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Group[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]Group 1[/TD]
[TD]Not Started[/TD]
[/TR]
[TR]
[TD]Group 2[/TD]
[TD]Not Started[/TD]
[/TR]
</tbody>[/TABLE]

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

 

[jtakw]

Hi,

Add additional criteria within {} as needed:

Book1
	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

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

 

[mystique07]

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

Hi,

Add additional criteria within {} as needed:

	A	B	C	D
Group	Status
Group 1	Not Started
Group 3	Not Started
Group 2	Not Started
Group 1	Not Started

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"]3[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet632​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D1[/TH]
[TD="align: left"]=SUM(COUNTIFS($B:$B,"Not Started",$A:$A,{"Group 1","Group 2"}))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]