muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all,
i need some excel formula to solve this below problem. with using COUNTIF/COUNTIFS how to counting data with 3 mode ;
<tbody>
</tbody>
i want to count with criteria based on adjacent value "name" column related with "checking" column
1) counting data "name" with "yes" criteria?
2) counting data "name" with "yes" & "no" criteria?
3) counting data "name" with blank "" criteria?
4) counting data "property" with criteria contains "name" and "yes" criteria
any assistance would be greatly appreciated..
regards
m.susanto
i need some excel formula to solve this below problem. with using COUNTIF/COUNTIFS how to counting data with 3 mode ;
name | property | checking |
robert | pc | yes |
monitor | ||
david | keyboard | no |
alfie | notebook | (empty cell/blank cell) |
lcd | ||
mouse | ||
zidan | rose | yes |
glass | ||
etc.. |
<tbody>
</tbody>
i want to count with criteria based on adjacent value "name" column related with "checking" column
1) counting data "name" with "yes" criteria?
2) counting data "name" with "yes" & "no" criteria?
3) counting data "name" with blank "" criteria?
4) counting data "property" with criteria contains "name" and "yes" criteria
any assistance would be greatly appreciated..
regards
m.susanto