We help IT Professionals succeed at work.

Counting discrepancies between two columns

dgd1212
dgd1212 asked
on
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.
Comment
Watch Question

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