KashifNawaz
New Member
- Joined
- Apr 11, 2019
- Messages
- 2
Hi, I have exported accounts data in excel from accounting software. Now stocks of the items are in Cartons (boxes); please help me, how to convert them into KG because record of all other items is on KG only. Please see attached excel sheet.
I can get the sum of boxes for desired products but cannot convert them to KG in same formula. Currently I am using Vlookup for each product, maintaining separate sheet for each individual product, converting the boxes into units and then in KG. But number of sheets are too much in single work book.
If we can use SUMIF to get sum/count of few items from big data, then there must be a way to get it multiplied with respective units.
I cannot find attach file option here.
I can get the sum of boxes for desired products but cannot convert them to KG in same formula. Currently I am using Vlookup for each product, maintaining separate sheet for each individual product, converting the boxes into units and then in KG. But number of sheets are too much in single work book.
If we can use SUMIF to get sum/count of few items from big data, then there must be a way to get it multiplied with respective units.
I cannot find attach file option here.
