Help with searchin group of numbers

  • Thread starter Thread starter carriagc
  • Start date Start date
C

carriagc

Anyone can help me with these problem i have???

I have a database which consists of a series of columns; in each of the
columns there
are various numbers, ineeds to be able to find out how many of an
interval of number is in all of the columns (for example, how many
numbers ranging between 3 and 6 are in the columns).


any help?
 
Hi
one way (assuming your numbers are in column A - D):
=SUMPRODUCT(($A$1:$A$999>=3)*($A$1:$A$999<=6))
this counts all numbers between 3 and 6 (including both boundaries)

HTH
Frank
 
Back
Top