Countif formula with 3 criteria selection

[sdm2211]

I have below data

A	B	C	D
Status	Assigned Group	Response	Resolve
Closed	Java	Met	Missed
Cancelled	C++	Met	Missed
Closed	C++	Missed	Met
Closed	SAP	Missed	Met
Closed	SAP	Met	Met
Cancelled	Java	Missed	Met
Cancelled	SAP	Met	Met

<tbody>
</tbody>

Pivot Result of the above

Status	Closed
Count of Status	Column Labels
Row Labels	Met	Missed	Grand Total
C++	1		1
Java		1	1
SAP	2		2
Grand Total	3	1	4

<tbody>
</tbody>

I want above result not in pivot but with formula like countifs etc.

 

[oldbrewer]

Status

Assigned Group

Response

Resolve

Closed

Java

Met

Missed

Cancelled

C++

Met

Missed

Closed

C++

Missed

Met

closed

closed

cancelled

cancelled

Closed

SAP

Missed

Met

met

missed

met

missed

Closed

SAP

Met

Met

C++

1

0

0

1

Cancelled

Java

Missed

Met

Java

0

1

1

0

Cancelled

SAP

Met

Met

SAP

2

0

1

0

Pivot Result of the above

Status

Closed

Count of Status

Column Labels

Row Labels

Met

Missed

Grand Total

C++

1

1

this is a simple sumproduct table

Java

1

1

SAP

2

2

the top left 1 obtained by

Grand Total

3

1

4

=SUMPRODUCT(($A$2:$A$8=H$4)*($B$2:$B$8=$G6)*($D$2:$D$8=H$5))

easy to add sub totals to it

<colgroup><col><col><col><col><col span="10"></colgroup><tbody>
</tbody>

 

[MARZIOTULLIO]

	A​	B​	C​	D​	E​
1​	status	Assigned Group	Response	Resolve
2​	Closed	Java	Met	Missed
3​	Cancelled	C++	Met	Missed
4​	Closed	C++	Missed	Met
5​	Closed	SAP	Missed	Met
6​	Closed	SAP	Met	Met
7​	Cancelled	Java	Missed	Met
8​	Cancelled	SAP	Met	Met
9​
10​
11​	Status	Closed
12​
13​	Row Labels	Met	Missed	Grand Total
14​	C++	1​		1​
15​	Java		1​	1​
16​	SAP	2​		2​
17​	Grand Total	3​	1​	4​

<tbody>
</tbody>

b14=COUNTIFS($A$2:$A$8,$B$11,$B$2:$B$8,$A14,$D$2:$D$8,B$13) copy across and down

di14=SUM(B14:C14) copy down

b17==SUM(B14:B16) copy across until missed

hide 0 custom formating=[=0]""