Sum / countif data range

  • Thread starter Thread starter Ed Peters
  • Start date Start date
E

Ed Peters

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:A10>6))
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
 
=SUMPRODUCT(--(B1:B10="London"),--(A1:A10>6),--(A1:A10<10))


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top