Excel - Count by condition

Excel - Count by condition

===================================

To count name (or any data) according to your condition, you can use "=countif(starting cell number: ending cell number, "condition")"

Example

Cell "c5" to cell "c17" got list of your customer which name starting with title. You want to count only name that start with Ms.

Then you can use "=countif(c5:c17,"Ms.*")

Watch VDO for an example.