count if

[avishaiz]

i want to count the number of rows where there is a difference between the sum of counted items (the numbers that we have in our data system) and the actual number of items on the shelf

how can i do that?

[avishaiz]

i need to be able to separate between items that are missing and items that are in excess

so i think this wont be good

[avishaiz]

i tried the two methods you recommended

now the thing is i got the same items on different shelves

so with an item that was counted twice in two different shelves i get a count of two items but i need only one since its the same item.

how can i solve this ?