I have below data
<tbody>
</tbody>
Pivot Result of the above
<tbody>
</tbody>
I want above result not in pivot but with formula like countifs etc.
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.