Count if function but with multiple groups

[msvoboda27]

HI,
I have a large table, and I'm trying to count the closed, in progress, resolved, and closed statuses. I have multiple assignment groups, and I would like to count the volume of each assignment group. There are multiple rows for the same assignment group as well. I can't use a simple count function since I would like to group the total by assignment group. Can someone please educate me?
Thanks!

 

[Asbestos_Jen]

Countifs should work for you. Try this:

Book1
	G	H	I	J	K
1	Requests by Assignment group	Closed	In Progress	Resolved	Pending
2	Group 1	1	0	1	1
3	Group 2	0	0	2	0
4	Grand total	1	0	3	1
Sheet1

Cell Formulas
Range	Formula
H2:K3	H2	=COUNTIFS($C$6:$C$11,H$1,$F$6:$F$11,$G2)
H4:K4	H4	=SUM(H2:H3)

 

[CubaRJ]

You need to have something like this?

Group 1: 3 assignments
Pending 1
Resolved 1
Closed 1

If so you have a Pivot Table to do the job or you can use countifs function:

Syntax:

=COUNTIFS(A2:A6,E2,B2:B6,F1)

Double Days Offshore Jan a Jul 2024 Sanitized.xlsm
	A	B	C	D	E	F	G
1	Inquiry State	Group			Summary	Group 1	Group 2
2	Resolved	Group 1			Closed	1	0
3	Closed	Group 1			Resolved	1	2
4	Resolved	Group 2			Pending	1	0
5	Resolved	Group 2
6	Pending	Group 1
Sheet2

Cell Formulas
Range	Formula
F2	F2	=COUNTIFS(A2:A6,E2,B2:B6,F1)
G2	G2	=COUNTIFS(A2:A6,G1,B2:B6,G1)
F3	F3	=COUNTIFS(A2:A6,E3,B2:B6,F1)
G3	G3	=COUNTIFS(A2:A6,E3,B2:B6,G1)
F4	F4	=COUNTIFS(A2:A6,E4,B2:B6,F1)
G4	G4	=COUNTIFS(A2:A6,E4,B2:B6,G1)

 

[CubaRJ]

HI,
I have a large table, and I'm trying to count the closed, in progress, resolved, and closed statuses. I have multiple assignment groups, and I would like to count the volume of each assignment group. There are multiple rows for the same assignment group as well. I can't use a simple count function since I would like to group the total by assignment group. Can someone please educate me?
Thanks!

View attachment 115160

One important caveat to consider is that both answers provided will use the cell value as reference. This means you should change the text in "Assignment group 1" to simply match the information you have in the table: "Group 1". Of course you can write in the formula syntax the "Group 1" too, but you´d better work in the first manner to avoid problems changing names of the group and etc..

 

[msvoboda27]

Thank you all for your time and response. It worked

 

[CubaRJ]

Glad to help!