jeudi 21 janvier 2021

How can I count values using If and Countif from a specific range?

I would like to know if its possible to count a number of value by doing a conditional statement example below:

If Cell A has value of cell range equal to "yes" then Cell B will display the count of Cell A that has the value of "yes".

Name1 - Yes     Count-Name1: 2
Name2 - No      Count-Name2: 0
Name3 - Yes     Count-Name3: 1
Name1 - Yes

Aucun commentaire:

Enregistrer un commentaire