If you need to sum a list of values in multiple columns, use the format =Sum(A:B) to sum all the currencies in columns A and B; if the columns also contain headers, Excel ignores this data and calculates only the figures.