Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting Values
What formula can I write to say: How many values in A1:A100 are greater than
B2+B3? |
#2
|
|||
|
|||
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? |
#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 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? |
#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 -- 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? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
project values based on other values | Excel Discussion (Misc queries) | |||
Save External Link Values | Excel Discussion (Misc queries) | |||
Counting values within a Date Range | Excel Discussion (Misc queries) |