problems with FREQUENCY formula

M

mark

Hi!

I am wondering if anyone could help with one problem. I am trying to
sort and calculate the frequencies from a long list. I know how to use
the FREQUENCY formula but if I have like to lists. for instance

A1:A10 and B1:B10

8 3100
7 1500
3 2000
4 1000
10 9000
1 8000
30 9000
20 5000
11 2000
22 1000

What I want is that I could get frequencies of these numbers, for
instance the frequency that the first is true with between 0<a<5 and
then 0<b<3000. So there is (A3;B3) are (3;2000) and they are counted
like one hit.

then 4 is also between 0 and 5, and the determined number is 1000, so
another hit. Then

A6 has a number of 1, but the B6 is 8000 which is outside the 0<b<3000
so we can't take it into account.

so we have for 0<a<5 and 0<b<3000 is 2
5<a<10 and 3000<b<6000 is 1
etc.

Just wondering if anyone would help me with this issue. I have a long
list of these and would help me a great deal if I could combine these
two by using advanced use of FREQUENCY formula. or maybe some
combination of FREQUENCY, COUNTIF AND OR formulas? Thank you so much
in advance!

Best regards,
Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top