phillexcel
New Member
- Joined
- Aug 5, 2014
- Messages
- 31
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?
=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?