countifs does not make difference in the value has 0 in start-CodePudding

Home > database > countifs does not make difference in the value has 0 in start

countifs does not make difference in the value has 0 in start

Time：01-26

Why Countifs is not considering value with 0 at start its answer should be 1 and 1 because B1 and B2 are two different value.

Any help will be appreciated.

CodePudding user response：

One option is SUMPRODUCT:

=SUMPRODUCT((A1=$A$1:$A$2)*(B1=$B$1:$B$2))