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
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
you might want to try:

=(COUNTIF(Y4:Y24,AND("<=10%", ">=-10%")))
 
Upvote 0
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
 
Upvote 0
Hi Paul:

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


formula in cell AA2 is ... =DCOUNTA(Y4:Y24,1,Y1:Y2)
 
Upvote 0
And using the COUNTIF function, adding to fine contribution by Oaktree, here is another formulation ...

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

Forum statistics

Threads
1,213,532
Messages
6,114,176
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top