ExcelBanter - Countif

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Countif (https://www.excelbanter.com/excel-discussion-misc-queries/247005-countif.html)

Laundone

Countif

I have two columns and need to count if column A =1 and Column B =0

T. Valko

Countif

Try this...

=SUMPRODUCT(--(A1:A10=1),--(B1:B10<""),--(B1:B10=0))

--
Biff
Microsoft Excel MVP

"Laundone" wrote in message
...
I have two columns and need to count if column A =1 and Column B =0

FSt1

Countif

hi
countif wont do that but sumproduct will. try this......

=SUMPRODUCT((A1:A10=1)*(B1:B10=0))

adjust the ranges to fit your columns.

Regards
FSt1

"Laundone" wrote:

I have two columns and need to count if column A =1 and Column B =0

All times are GMT +1. The time now is 01:11 AM.