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.
dgd1212Asked:
Who is Participating?
 
als315Commented:
Try
=SUM(IF(W2:W13>X2:X13,1,0))
where X2:X13 - your range, W2- first cell in column
after editing you should convert formula to array formula:
{=SUM(IF(W2:W13>X2:X13,1,0))}
pressing CTRL+SHIFT+ENTER simultaneously
Count.xlsx
0
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.