Hi all,

I've data that I need to count if it's between a certain value

eg:

London,3
London,7
Rome,1
Rome,5
Rome,5

=SUM((B1:B10="London")*(A1:A106))
This is as an array

So the above would give an answer of London 1, however I would like to
use instead of 6 a range, eg 6 and < 10.
How would I do that?

Should I be using countif.

Thanks,

Ed