Linda,

Yes, it is possible. Open a new sheet and try data - consolidate. Under
Reference you put the range of Northern Division and add it. Then Southern
Division and add it. See whether you are getting the combined values.

Regards,

Jaleel

"Linda in Pleasanton" wrote:

Need to add values in two identical excel files together to create a new file
with combined values. For example, NorthernDivision + SouthernDivision =
Total Company information.