SUMIF that count occurrencies

[Bri]

What I got

__A____|__B_______|__C______
_Name__|_discount_|_purchase
John___|__________|_x_______
Andrew_|_x________|_x_______
William|_x________|_________
Bart___|__________|_x_______

I want to count all purchases without discount (here will be 2 purchases).

SUMIF doesn’t work because it need values to sum (when i place “1” instead of “x” in column C it works).

COUNTIF works separately in each column because doesn’t have condition (giving 2 and 3 as a result).

Cannot use in this example count nonblank in one column and then count non blank in second then subtract discount occurrency is very important here.

CALC 5.2.1.2 PL

[PYS]

Hi

=SUMPRODUCT(B2:B5<>"x";C2:C5="x")

Regards

[Bri]

Excellent
Never thought about this function 'cos in polish it’s called ~“SUMofMULTIPLICATION” (SUMA.ILOCZYNÓW) - and I do not multiply anything there, so was skipping it.
Thank You