Excel: Counting data using countif/countifs formula

hi all, 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
david keyboard no
alfie notebook (empty cell/blank cell)
zidan rose yes
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

This question generated 30 answers. To proceed to the answers, click here.

This thread is current as of April 18, 2014.

For more resources for Microsoft Excel