Excel formula help

[djsmitty88]

I used two columns to come up with a formula and now I want to delete the two columns while keeping the column with the totals from the formula used.  Does that make sense?  And is it possible?

[#2]

You may copy the range with totals and paste as values on the same place