Once combined, you need to change the merged data to values ... columns have headers, give the new column a header name. In ...

Both methods will always give you the same result, so you can use whichever one is more convenient. Here's how to do it. AutoSum works best when you have a column ... values you want to sum ...