Is this what your after.....
VBA Code:
=IF(A3="","",SUMPRODUCT(1*MID(A3,ROW(INDIRECT("1:"&LEN(A3))),1)))
=IF(B3="","",SUMPRODUCT(1*MID(B3,ROW(INDIRECT("1:"&LEN(B3))),1)))
=IF(C3="","",SUMPRODUCT(1*MID(C3,ROW(INDIRECT("1:"&LEN(C3))),1)))
This is it Michael this sums all the quantity per Bin..........Now I would like to add
all the totals of these Boxes, E2...... Skids F2.... Filing Cabinets EG ...this is a pretty simple formula for you to write?
This way I can see how many I have of each per Bin, and the total of each for all sites.
Thanks again, much appreciated.