ExcelBanter - COUNTIF function when 2 conditions exist?

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

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

- - COUNTIF function when 2 conditions exist? (https://www.excelbanter.com/excel-worksheet-functions/57782-countif-function-when-2-conditions-exist.html)

Inquiring Minds

COUNTIF function when 2 conditions exist?

Using EXCEL 2000, I need the COUNTIF function when I want 2 conditions in
separate columns to be counted.

Peo Sjoblom

COUNTIF function when 2 conditions exist?

=SUMPRODUCT(--(A2:A50=cond1),--(B2:B50=cond2),C2:C50)

--

Regards,

Peo Sjoblom

"Inquiring Minds" <Inquiring wrote in
message ...
Using EXCEL 2000, I need the COUNTIF function when I want 2 conditions in
separate columns to be counted.

All times are GMT +1. The time now is 02:35 PM.