ExcelBanter - Using Countif on multiple columns

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

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

- - Using Countif on multiple columns (https://www.excelbanter.com/excel-worksheet-functions/99581-using-countif-multiple-columns.html)

ingeman

Using Countif on multiple columns

Why doesn't the following formula work? =count(if(k2:k20,"1",j2:j20,"<40"))

Biff

Using Countif on multiple columns

"ingeman" wrote in message
...
Why doesn't the following formula work?
=count(if(k2:k20,"1",j2:j20,"<40"))

Try this:

=SUMPRODUCT(--(K2:K20=1),--(J2:J20<40))

Biff

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