Most valuable professional
  • Hot Topics

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 robert david alfie zidan 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:

This article includes the following tags:

  • Excel
  • Microsoft Excel