Sum / countif data range
 

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

Sum / countif data range
 

=SUMPRODUCT(--(B1:B10="London"),--(A1:A106),--(A1:A10<10))


--
---
HTH

Bob


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



"Ed Peters" wrote in message
...
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

Sum / countif data range
 

Hi,

Possibly

=SUM((B1:B10="London")*(A1:A106))-SUM((B1:B10="London")*(A1:A1010))

Mike

"Ed Peters" wrote:

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