I have tested export report(Region by Year Revenue) to XLS on yellowfin 7 and open file on the excel but columns number will must be convert to number for reached to use the function summary.
Also, I have tested export report(Region by Year Revenue) to XLS yellowfin 6.3 when I open file and used the function summary can use AutoSum to summarize the Invoiced column data.