Hello All,
I have wrestled with this formula for weeks but I cannot seem to get it to
work: =IF(Totals!B4>0,CONCATENATE(Totals!B4,"-",Totals!B3),"")
The formula above works, however I would like to have this formula work
accross columns. This sheet is a summary order sheet, which references
another sheet. On the sheet it is referencing along the top I have items,
down the side there will be customers. What should happen is if the
referenced sheet field is blank nothing is ordered or showed on the summary
sheet; if the number is 1 or>, the total quantity and the item will appear
e.g. 5 - peaches, in Mr. Smith's row. The above formula works for just one
column, I would like it to show all orders, e.g. in Mr. Smith's row
5-peaches, 3-apples, 2-pears, etc.. There are over 100 items so I cannot
repeat the formula above for all columns. Any help would be appreciated.
Sincerely,
Dave
Bookmarks