Using “Paste Special” with ‘Add’, will allow you to take two sets of data and add them together without having to create an extra column and a formula.  In this example one company purchased another company with the same product line.  We need to combine the sales figures for the year of the two identical products.