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

[phillexcel]

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?

 

[VoG]

Try

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

 

[pgc01]

Hi

Another option:

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

 

[phillexcel]

Hi

Another option:

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

The second formula works - great, thanks!

 

[pgc01]

You're welcome. Thanks for the feedback.

The second formula works - great, thanks!

Remark: the first one also works.