Thread
:
Countif
View Single Post
#
2
Posted to microsoft.public.excel.misc
T. Valko
external usenet poster
Posts: 15,768
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
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko