Counting Values
 

What formula can I write to say: How many values in A1:A100 are greater than
B2+B3?

Try this

=COUNTIF(A1:A100,""&(B2+B3))

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Adam1 Chicago" wrote in message
...
What formula can I write to say: How many values in A1:A100 are greater
than
B2+B3?

Thanks, that worked well. One more question: How many values in A1:A100 are
B2-B3 and <B2+B3? (I tried using AND and the trick you showed me, but that
didn't seem to work.) Thanks

"Ron de Bruin" wrote:

Try this

=COUNTIF(A1:A100,""&(B2+B3))

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Adam1 Chicago" wrote in message
...
What formula can I write to say: How many values in A1:A100 are greater
than
B2+B3?

Something like this(I am sure there are better ways)

=SUM((A1:A100(B2-B3))*(A1:A100<(B2+B3)))
Array entered (Ctrl-Shift-Enter)

See Chip's Site about
Array formulas
http://www.cpearson.com/excel/array.htm





--
Regards Ron de Bruin
http://www.rondebruin.nl



"Adam1 Chicago" wrote in message
...
Thanks, that worked well. One more question: How many values in A1:A100
are
B2-B3 and <B2+B3? (I tried using AND and the trick you showed me, but
that
didn't seem to work.) Thanks

"Ron de Bruin" wrote:

Try this

=COUNTIF(A1:A100,""&(B2+B3))

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Adam1 Chicago" wrote in message
...
What formula can I write to say: How many values in A1:A100 are greater
than
B2+B3?

That works, too; thanks a lot for your help.

"Ron de Bruin" wrote:

Something like this(I am sure there are better ways)

=SUM((A1:A100(B2-B3))*(A1:A100<(B2+B3)))
Array entered (Ctrl-Shift-Enter)

See Chip's Site about
Array formulas
http://www.cpearson.com/excel/array.htm





--
Regards Ron de Bruin
http://www.rondebruin.nl



"Adam1 Chicago" wrote in message
...
Thanks, that worked well. One more question: How many values in A1:A100
are
B2-B3 and <B2+B3? (I tried using AND and the trick you showed me, but
that
didn't seem to work.) Thanks

"Ron de Bruin" wrote:

Try this

=COUNTIF(A1:A100,""&(B2+B3))

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Adam1 Chicago" wrote in message
...
What formula can I write to say: How many values in A1:A100 are greater
than
B2+B3?