I have a table with months of the year as individual columns. Is there any way to create a summary table to calculate the yearly totals. I believe this would be possible in Excel using a horizontal lookup.
It depends on exactly you want to structure the new table, and whether it has to be a separate table.
The simplest would be to use the column Sum feature to calculate the total for each column.
And I would strongly recommend that you have values in a single column, rather than a column for each month. You can still create a view with monthly columns, but yoy sacrifice a huge amount of flexibility by solutions into monthly columns.