Countif Formula

[jayjaysb]

Hi all,

Looking for formula please

In Column C I have 2 options In Process and Awaiting Process
In Column D I have 4 options Repaired, Cannot be repaired, Awaiting Part, Log No.

Below I have 2 In Process = Repaired, 1 In Process = Cannot be repaired.
2 Awaiting Process = Awaiting Log No

Status Outcome
In Process Repaired
In Process Repaired
In Process Cannot be repaired
Awaiting Process Awaiting Log No
Awaiting Process Awaiting Log No

Thanks

JJSB

 

[Sam_D_Ben]

Excel 2013/2016
	C	D
1	In Process	Repaired
2	Awaiting Process	Cannot be repaired
3		Awaiting Part
4		Awaiting Log No
Sheet3

This seems your table. But not clear with what do you mean by "Status Outcome" and "Coutif" formula.

 

[Toadstool]

Hi JJSB,

I'm not sure what you need but as the subject is "Countif" I'm guessing you want a count of all combinations in columns C & D. Assuming neither can be blank then there's 8 options.

	C	D	E	F	G	H
1	WIP/Waiting	Status		Summary		Count
2	In Process	Repaired		In Process	Repaired	3
3	Awaiting Process	Cannot be repaired		In Process	Cannot be repaired	0
4	In Process	Awaiting Part		In Process	Awaiting Part	3
5	Awaiting Process	Log No.		In Process	Log No.	0
6	In Process	Repaired		Awaiting Process	Repaired	0
7	Awaiting Process	Awaiting Part		Awaiting Process	Cannot be repaired	1
8	In Process	Awaiting Part		Awaiting Process	Awaiting Part	3
9	Awaiting Process	Log No.		Awaiting Process	Log No.	2
10	In Process	Repaired
11	Awaiting Process	Awaiting Part
12	In Process	Awaiting Part
13	Awaiting Process	Awaiting Part

<tbody>
</tbody>

Countif​

Worksheet Formulas Cell Formula H2 =COUNTIFS(C:C,F2,D:D,G2) <tbody> </tbody>

<tbody>
</tbody>

 

[jayjaysb]

Hi Sam, Sorry. I couldn't get it to paste the table, But Toadstool below has got what I meant. Thanks for your speedy reply JJSB

 

[jayjaysb]

Hi JJSB,

I'm not sure what you need but as the subject is "Countif" I'm guessing you want a count of all combinations in columns C & D. Assuming neither can be blank then there's 8 options.

	C	D	E	F	G	H
1	WIP/Waiting	Status		Summary		Count
2	In Process	Repaired		In Process	Repaired	3
3	Awaiting Process	Cannot be repaired		In Process	Cannot be repaired
4	In Process	Awaiting Part		In Process	Awaiting Part	3
5	Awaiting Process	Log No.		In Process	Log No.
6	In Process	Repaired		Awaiting Process	Repaired
7	Awaiting Process	Awaiting Part		Awaiting Process	Cannot be repaired	1
8	In Process	Awaiting Part		Awaiting Process	Awaiting Part	3
9	Awaiting Process	Log No.		Awaiting Process	Log No.	2
10	In Process	Repaired
11	Awaiting Process	Awaiting Part
12	In Process	Awaiting Part
13	Awaiting Process	Awaiting Part

<tbody>
</tbody>

Countif​

Worksheet Formulas Cell Formula H2 =COUNTIFS(C:C,F2,D:D,G2) <tbody> </tbody>

<tbody>
</tbody>

Thanks Toadstool, Yes that is what I am looking for. Many thanks for you help. JJSB

 

[Sam_D_Ben]

Hi Sam, Sorry. I couldn't get it to paste the table, But Toadstool below has got what I meant. Thanks for your speedy reply JJSB

Thats ok, The reason i asked you about countif and stuff, cause looking at your data, seems you can easily achieve the result using "Pivot". I guess you don't need to create any extra table or any formula required.

I worked on Toadstool data to show you that.