I am currently working on a spreadsheet and have hit a brief stumbling point. I guess what I`m trying to do is =sum(b1*(text(a1,"")) - which doesn't work (needless to say)
which should multiply my text value as follows
chair 3 chair chair chair
table 2 table table
cushion 3 cushion cushion cushion
Can any of you experts lend a hand??