I have two separate columns in an excel spreadsheet calculating gambling profits
when a free bet is placed, the total payout column and the total won column will be the same
i want to write an excel formula that will count how many times these two columns have the same value within the same row
I was able to use COUNTIF and COUNTIFS formulas for everything else I was trying to accomplish, but I can not figure this one out
thank you
CodePudding user response:
Using SUMPRODUCT
and the double unary --
:
=SUMPRODUCT(--(B2:B5=D2:D5))