test data in two columns, return totals

E

eugene

Hi,

I would like to test numbers in two columns against each other and count the
amount. EG - how many in column A within interval 1 to 2 but only if number
in column B (same row) is within interval 3 to 4. Columns are very long and
simply want to know how many rows match my criteria.

Can do this as a macro, but would like to use worksheet functions. If you
know, please tell me the names of the functions that i would need to use.
Don't need exact statements unless what I am asking is complex.


Eugene
 
J

JMB

try:
=SUMPRODUCT(--(A1:A7>1),--(A1:A7<2),--(B1:B7>3),--(B1:B7<4))
change ranges as needed and change < to <= and > to >= if needed.
 
E

eugene

thanks, that's easy

--
eugene


JMB said:
try:
=SUMPRODUCT(--(A1:A7>1),--(A1:A7<2),--(B1:B7>3),--(B1:B7<4))
change ranges as needed and change < to <= and > to >= if needed.
Click to expand...
 

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

Similar Threads

Excel Comparing two columns 1
return proper match from three columns 2
Vlookup formula combining two columns 2
compare contents of two adjacent columns 6
Add totals based on more than one criteria 3
Lookup based on two variables and return a third 3
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
Comparing data from two columns 2

Top