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 |
---|
WIP/Waiting | Status | | | | | |
In Process | Repaired | In Process | Repaired | | | |
Awaiting Process | Cannot be repaired | In Process | Cannot be repaired | | | |
In Process | Awaiting Part | In Process | Awaiting Part | | | |
Awaiting Process | Log No. | In Process | Log No. | | | |
In Process | Repaired | Awaiting Process | Repaired | | | |
Awaiting Process | Awaiting Part | Awaiting Process | Cannot be repaired | | | |
In Process | Awaiting Part | Awaiting Process | Awaiting Part | | | |
Awaiting Process | Log No. | Awaiting Process | Log No. | | | |
In Process | Repaired | | | | | |
Awaiting Process | Awaiting Part | | | | | |
In Process | Awaiting Part | | | | | |
Awaiting Process | Awaiting Part | | | | | |
<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: center"]Summary[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Count[/TD]
[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
</tbody>
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H2[/TH]