Forum Discussion
CountIFs with multiple criteria and logic.
I am trying to create a countif formula that counts the number of times a part number show up in a different sequence, for example, that table below the first check if the part number is the same as ...
Fernando Salgueiro , taht could be
=SUMPRODUCT(($B$2:$B$20=B22)*($B$2:$B$20=OFFSET($B$2:$B$20,1,0)))
if I understood your logic correctly