Quote:
Originally Posted by gillenr
I can't do a "countif" using a value range like ">10<20". Am I doing something wrong, or should I be using something other than "countif"?
Thanks.
|
Try this:
=SUM(IF(A3:A32>10,IF(A3:A32<20,1,0)))
There IS a trick to it, though... Excel calls this an "array formula", so what you have to do is type in the formula IN THE FORMULA BAR (it typically is the text area right above the spreadsheet and has the equal sign next to it) AND THEN do a "CTRL-SHIFT-ENTER" while still in the FORMULA BAR. If you don't do this, you'll get a #VALUE! error in the cell where you put the formula.
YOU HAVE TO DO THE "CTRL-SHIFT-ENTER" STEP IN THE FORMULA BAR
EVERY TIME YOU EDIT THE FORMULA!!!
Still in all...