help with countif formula

[acandray]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello, I have a list of numbers and I want to count the number of cells that contain numbers within a range.

For example, I want to know how many of the cells in a row have numbers between -9 and -5. I've had trouble constructing the formula and also managing negative numbers. I understand i must use the COUNTIF formula?? PLEASE HELP!

 

[Carl Witthoft]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello, I have a list of numbers and I want to count the number of cells that
contain numbers within a range.

For example, I want to know how many of the cells in a row have numbers
between -9 and -5. I've had trouble constructing the formula and also
managing negative numbers. I understand i must use the COUNTIF formula??
PLEASE HELP!

Start small: to find numbers in a range, one easy way is:

=IF((AND(A1>-9,A1<-5)),value_if_true,value_if_false)

You can extend that structure to your COUNTIF formula

 

[Bob Greenblatt]

Start small: to find numbers in a range, one easy way is:

=IF((AND(A1>-9,A1<-5)),value_if_true,value_if_false)

You can extend that structure to your COUNTIF formula

And, realize that you must remember your basic algebra, because Excel does.
-6 is GREATER than -9 for example, not LESS than.