Izila
New Member
- Joined
- Aug 27, 2019
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
Hi All,
I have a series of columns for orders on my spreadsheet. The furthest left column contains item numbers, the second column contains the quantities ordered whilst the final column contains the item names.
I'm trying to find a way whereby any items that are ordered multiple times have their quantity summed and placed next to the item name column. I have experimented with VLOOKUP and SUMIF but I've had no success.
Any help is greatly appreciated.
Thanks in advance,
Izila
I have a series of columns for orders on my spreadsheet. The furthest left column contains item numbers, the second column contains the quantities ordered whilst the final column contains the item names.
I'm trying to find a way whereby any items that are ordered multiple times have their quantity summed and placed next to the item name column. I have experimented with VLOOKUP and SUMIF but I've had no success.
Any help is greatly appreciated.
Thanks in advance,
Izila