I have excel data file like:

How can I count Yes/No Row # 2 to 6 then Row # 7 to 11 and Row # 12 to 20?

Pls. suggest if possible in excel.

CodePudding user response：

Use the function COUNTIF instead of COUNT

COUNTIF basically returns a count value of the cells that meet a certain criterion provided by you

Syntax: =COUNTIF(Where do you want to look?, What do you want to look for?)

Eg) =COUNTIF(C2:C6,"Yes")

If you need further help, you can look it up in the Microsoft documentation, link below: