A
Adam1 Chicago
What formula can I write to say: How many values in A1:A100 are greater than
B2+B3?
B2+B3?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron de Bruin
Try this
=COUNTIF(A1:A100,">"&(B2+B3))
=COUNTIF(A1:A100,">"&(B2+B3))
A
Adam1 Chicago
Thanks, that worked well. One more question: How many values in A1:A100 are
didn't seem to work.) ThanksB2-B3 and <B2+B3? (I tried using AND and the trick you showed me, but that
R
Ron de Bruin
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
=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
A
Adam1 Chicago
That works, too; thanks a lot for your help.
Ron de Bruin said: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