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

Group	Status
Group 1	Not Started
Group 2	Not Started

<tbody>
</tbody>

=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
1	Group	Status		3
2	Group 1	Not Started
3	Group 3	Not Started
4	Group 2	Not Started
5	Group 1	Not Started

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet632​

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

<tbody>
</tbody>