# =countif(i2:i328,">1")-countif(i2:i328,">10")

#### phillexcel

##### New Member
I have the following formula which helps me calculate the number of occurances in the I cell range that are greater than 1 up to a value of 10 which is.....

=COUNTIF(I2:I328,">1")-COUNTIF(I2:I328,">10")

However in addition to this I now want it to take into account those numbers that are only against that individual, so for example in cells B2:B328 I have the name 'Alex'

Please can some help me with how I would do this?

### Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Try

=SUMPRODUCT(--(I2:I238>1),--(I2:I238<=10),--(B2:B328="Alex"))

Hi

Another option:

=COUNTIFS(B2:B328,"Alex",I2:I328,">1",I2:I328,"<=10")

Hi

Another option:

=COUNTIFS(B2:B328,"Alex",I2:I328,">1",I2:I328,"<=10")

The second formula works - great, thanks!

You're welcome. Thanks for the feedback.

The second formula works - great, thanks!

Remark: the first one also works.

Replies
4
Views
394
Replies
4
Views
165
Replies
3
Views
509
Replies
4
Views
314
Replies
4
Views
345

1,220,980
Messages
6,157,189
Members
451,404
Latest member
Probe

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

### Which adblocker are you using?

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

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