CountIF Plus or Minus 10%

Brennanp

New Member
Joined
Jul 31, 2005
Messages
15
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%")

Thanks for your help.
Paul
 

iggydarsa

Well-known Member
Joined
Jun 28, 2005
Messages
1,647
you might want to try:

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

Brennanp

New Member
Joined
Jul 31, 2005
Messages
15
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
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
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
Joined
Mar 12, 2002
Messages
11,454
And using the COUNTIF function, adding to fine contribution by Oaktree, here is another formulation ...

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

Forum statistics

Threads
1,078,249
Messages
5,339,079
Members
399,276
Latest member
Donjayok

Some videos you may like

This Week's Hot Topics

Top