How to enter and sum multple values (up to 100) in a single cell

[ashp123]

Hello,

the formula below checks a list of my SKUs which contains how much stock is available. The issue is that the SKUs are always changing for the same item and may have multiple SKUs for which the the list needs to be cheked and added togeather. For this I have a list of ALL the SKUs per cell for each product, for example;

Dashboard!$I7 (PHONE1, PHONE2,PHONE3, PHONE4)

SUMPRODUCT(--('Inventory'!$B$4:$B$5001=Dashboard!$I7),ISNUMBER(SEARCH("SELLABLE",'Inventory'!$F$4:$F$5001)),'Inventory'!$G$4:$G$5001)

I need it to be as simple as possible, for example if I wanted to return the 2nd SKU in the cell something like;

SUMPRODUCT(--('Inventory'!$B$4:$B$5001=Dashboard!$I7{2st cell value}),ISNUMBER(SEARCH("SELLABLE",'Inventory'!$F$4:$F$5001)),'Inventory'!$G$4:$G$5001)

any help greatly appreciated,

ash

 

[oldbrewer]

code	item	stock
1	phonea	23
2	phoneb	28
3	phonec	21
4	phoned	19
5	phonea	24
6	phoneb	26
7	phonec	28
8	phoned	30
9	phonee	10
10	phonea	15			phonea	62
			224		phoneb	54
					phonec	49
					phoned	49
					phonee	10
							224
				is this what you want to end up with

<colgroup><col width="64" span="11" style="width:48pt"> </colgroup><tbody>
</tbody>