How to give range in countifs using cell in excel-CodePudding

Home > front end > How to give range in countifs using cell in excel

How to give range in countifs using cell in excel

Time：04-30

Iam wondering if someone can help me with this Excel formula about COUNTIFS , instead of giving range using numbers ie.

COUNTIFS(A2:A200,">200",A2:A200,"<=900")

Can we use cells for range reference ie.

COUNTIFS(A2:A200,">C7",A2:A200,"<=C8")

I've actually tried this but getting 0 as output. Can someone help me with this.

CodePudding user response：

Try the below formula.

=COUNTIFS(A2:A200,">"&C7,A2:A200,"<="&C8)