Counting discrepancies between two columns

I have two columns, W and X. W is for ordered and X is for shipped. I already have conditional formatting to check the row with W and X but looking to how you count the discrepancies when they are not equal - as in zero shipped or partial shipments.
Thanks in advance for any suggestions.
Who is Participating?
where X2:X13 - your range, W2- first cell in column
after editing you should convert formula to array formula:
pressing CTRL+SHIFT+ENTER simultaneously
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.