# CountIF Plus or Minus 10%

#### Brennanp

##### New Member
Hi, I want to perform a countif on variances plus or minus 10% from a given column.Do Ineed more than 1 criteria or can I specify the criteria range from 10% to - 10%. This is what I currently have.

=(COUNTIF(Y4:Y24,"<=10%")

Paul

#### iggydarsa

##### Well-known Member
you might want to try:

=(COUNTIF(Y4:Y24,AND("<=10%", ">=-10%")))

#### Brennanp

##### New Member
That formula does not return any values. My range contains values between -100% and 100%. There are are values less than 10% that are not being picked up by that formula. Any ideas? Thanks Paul

#### Oaktree

##### MrExcel MVP
=COUNTIF(Y4:Y24,"<=10%") - COUNTIF(Y4:Y24,"<-10%")

#### Yogi Anand

##### MrExcel MVP
Hi Paul:

Here is another way ... using the DCOUNT function ...
Book1
XYZAAAB
1
2
3Entry
41%
52%
63%
74%
8-5%
9-11%
1011%
112%
12
 Sheet2

formula in cell AA2 is ... =DCOUNTA(Y4:Y24,1,Y1:Y2)

#### Yogi Anand

##### MrExcel MVP
And using the COUNTIF function, adding to fine contribution by Oaktree, here is another formulation ...

=SUM(COUNTIF(Y4:Y24,{"<=10%","<-10%"})*{1,-1})

#### Brennanp

##### New Member
It worked. Thanks for your help.