Add columns to get total

[Anonymous]

Hi all, thanks very much for all the help. You all are great

So I have a table

Project    Jan     Feb    Mar    Apr 

A             10      20      10      5

B               5        5        5       5

And I want to create a chart that totals all the columns. so result is:

Project    Jan    Feb    Mar   Apr  Total

A             10     20      10      5      45

B               5       5        5       5      20

Thanks very much

PS I know this must be one of the simplest things ever but cant figure out. might be overthinking it. Tried using addcolumn amd sumx  with no joy

[Anonymous · Accepted solution]

File attached.

Best

D

[Anonymous]

Thanks for the quick response. 

It works!