multiple criteria ifcount()

N

NAGBEAR

Is it possible to set multiple criteria in ifcount() function? I want to
count the number of cells in a range that have a value grreater than x and
less than y
 
P

Paul S

NAGBEAR said:
Is it possible to set multiple criteria in ifcount() function? I want
to
count the number of cells in a range that have a value grreater than x
and
less than y
Click to expand...

Hi Nagbear

Try something like this {=SUM((A2:A10>x)*(B2:B10<y))}, enterred as an
array with CTRL/SHIFT/ENTER
 
Top