Help with searchin group of numbers

[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?

 

[Frank Kabel]

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

 

[carriagc]

thanks a lot!