Forum Discussion
BarryRyan25
Sep 28, 2021Copper Contributor
Formula Assistance Counting Pallets
Hi,
I'll try to explain this as quick/best I can
I want to create a formula that will determine how many pallets went out as a full pallet versus a partial pick.
For example, a full pallet of our products would be 60. 120 would be 2 pallets and so on.
Anything that is not divisible by 60 I would count as a partial pick and would not include in the report.
I was using COUNTIF's but they don't work 100% as if I use countif(range,120) it would count it as 1 pallet and not 2.
Any assistance would be appreciated as I've to do this for approximately 9000 rows.
1 Reply
- Riny_van_EekelenPlatinum Contributor