# Multiple COUNTIF ?

#### Nutestarvi

##### New Member
I think this is a simple one. The picture explains it all but this is what I want to do:

Of all cells larger than "X"
How many are larger than "Y"

Thank you for all the support guys! You are legends!

Picture: https://postimg.org/image/5d9qk6c8h/

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Excel 2012
AB
1103
2501
3
410
550
650
7100
Sheet4
Cell Formulas
RangeFormula
B1=COUNTIF(\$A\$4:\$A\$7,">"&A1)

I cannot see your picture (site blocked for me), but you should just be able to check for the number of records greater than the larger of X and Y.

For example, if there are 20 records bigger than 5 (X) and 12 records bigger than 10 (Y), then your answer would just be 10 (since Y is bigger than X, X is inconsequential and really doesn't come into play here).

Just do a COUNTIF of the number over 50 divided by a COUNTIF of the number over 25.

Haha yeah. I feel stupid now! I knew it was simple but my brain was even simpler :D

Thanks for a mega quick reply! This must be the best forum in the world for support!

Haha yeah. I feel stupid now! I knew it was simple but my brain was even simpler :D

Thanks for a mega quick reply! This must be the best forum in the world for support!
You are welcome!

No worries! We all have days like that. I usually blame it on a lack of caffeine early in the morning!

Last edited:

Replies
3
Views
195
Replies
3
Views
357
Replies
1
Views
1K
Replies
1
Views
538
Replies
3
Views
770

1,196,476
Messages
6,015,435
Members
441,894
Latest member
Zululander

### 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?

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