I've searched around, but been unable to determine why my count(iif's haven't been working. Hopefully you can help me out..
Table: Inventory Columns: A, B, Item_No, QTY, Location, F, G, H, I, J,
Normally we have 1-10 items in each location, and a row is shown for each item in each location.
I have a form that takes the current inventory location and adds or subtracts 1 from it to determine the inventory location next to it. (Front and back positions)This new location is in form: Sheet1, Text31.
On this same form, I'm trying to determine how many items are in the location next to the current one so I have tried to use:
I keep getting a #error with this, and am not sure why.
I also need to find out how many unique items are in the current position, but am not sure exactly how to format that one. I guess it would be similar to: Count # of different items in Item_No if the location matches Sheet1, Text31.