G Guest Jan 7, 2005 #1 What formula can I write to say: How many values in A1:A100 are greater than B2+B3?
G Guest Jan 7, 2005 #3 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 Click to expand... didn't seem to work.) Thanks
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 Click to expand... didn't seem to work.) Thanks
R Ron de Bruin Jan 7, 2005 #4 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
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
G Guest Jan 7, 2005 #5 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 Click to expand...
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 Click to expand...
