govind_bhuse
New Member
- Joined
- Mar 16, 2015
- Messages
- 15
Dear All,
I am trying to create a COUNTIFS formula which can fetch me the below desired result.
In below example one of the source cell is empty but I want countifs formula to consider this as a count.
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Kindly help me please. Thanks in advance.
I am trying to create a COUNTIFS formula which can fetch me the below desired result.
In below example one of the source cell is empty but I want countifs formula to consider this as a count.
Name | Middle Name | Surname | Count | Formulas | I Want Answer |
Omkar | Govind | Bhuse | 1 | =COUNTIFS($B$3:$B$13,B3,$C$3:$C$13,C3,$D$3:$D$13,D3) | |
Manasvi | Govind | Bhuse | 1 | =COUNTIFS($B$3:$B$13,B4,$C$3:$C$13,C4,$D$3:$D$13,D4) | |
Swaroop | Indrajit | 0 | =COUNTIFS($B$3:$B$13,B5,$C$3:$C$13,C5,$D$3:$D$13,D5) | 2 | |
Swaroop | Indrajit | 0 | =COUNTIFS($B$3:$B$13,B6,$C$3:$C$13,C6,$D$3:$D$13,D6) | 2 | |
Rupali | Govind | Bhuse | 3 | =COUNTIFS($B$3:$B$13,B7,$C$3:$C$13,C7,$D$3:$D$13,D7) | |
Rupali | Govind | Bhuse | 3 | =COUNTIFS($B$3:$B$13,B8,$C$3:$C$13,C8,$D$3:$D$13,D8) | |
Rupali | Govind | Bhuse | 3 | =COUNTIFS($B$3:$B$13,B9,$C$3:$C$13,C9,$D$3:$D$13,D9) | |
Indrajit | Bhuse | 0 | =COUNTIFS($B$3:$B$13,B10,$C$3:$C$13,C10,$D$3:$D$13,D10) | 2 | |
Indrajit | Bhuse | 0 | =COUNTIFS($B$3:$B$13,B11,$C$3:$C$13,C11,$D$3:$D$13,D11) | 2 | |
Bhagyashri | Indrajit | Bhuse | 2 | =COUNTIFS($B$3:$B$13,B12,$C$3:$C$13,C12,$D$3:$D$13,D12) | |
Bhagyashri | Indrajit | Bhuse | 2 | =COUNTIFS($B$3:$B$13,B13,$C$3:$C$13,C13,$D$3:$D$13,D13) |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Kindly help me please. Thanks in advance.