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
monitor
david keyboard no
alfie notebook (empty cell/blank cell)
lcd
mouse
zidan rose yes
glass
etc..
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