PDA

View Full Version : Excel question.


gillenr
01-20-2006, 10:50 AM
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.

rokitman
01-20-2006, 12:38 PM
Make them two separate conditions.

gillenr
01-20-2006, 05:51 PM
Already doing that - was hoping for something more "elegant".

arkansasman
01-20-2006, 07:58 PM
I can't do a "countif" using a value range like ">10<20".

Why don't you use nested IF statements?

mainardi
01-21-2006, 02:28 AM
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...:cool: :cool: :cool: