ExcelBanter - multiple criteria ifcount()

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - multiple criteria ifcount() (https://www.excelbanter.com/excel-worksheet-functions/55497-multiple-criteria-ifcount.html)

NAGBEAR

multiple criteria ifcount()

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

Duke Carey

multiple criteria ifcount()

=SUMPRODUCT(--(A1:A1005),--(A1:A100<10))

"NAGBEAR" wrote:

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

Paul S

Quote:

Originally Posted by 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

Hi Nagbear

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

All times are GMT +1. The time now is 07:49 AM.