countif between numbers

[marcellorama]

i have a problem where i can't figure out how to count between numbers...example..i want to count how many times a column of numbers falls between say a range of 140 to 160 using the countif formula..need help...thanks

[Yogi Anand]

Hi marcellorama:
Welcome to the board. One of the ways is to usethe following array formula ... with CTRL+SHIFT+ENTER

=SUM(IF(A2:A9>=140,IF(A2:A9<=160,1,0)))

________________
Yogi Anand

Edit: Deleted inactive website from hardcoded signature

[ This Message was edited by: Yogi Anand on 2003-01-19 12:53 ]

[Asala42]

Hey,

i have a problem where i can't figure out how to count between numbers...example..i want to count how many times a column of numbers falls between say a range of 140 to 160 using the countif formula..need help...thanks

Both of these should work:

=COUNTIF(Range,"<160")-COUNTIF(Range,">140")

or

=SUMPRODUCT((Range>140)*(Range<160))

Hope that helps,
Adam