Choosing Columns to add together

[nicksoph]

Im looking for some guidance on a method to achieve the following;

I have an 8 column spreadsheet with between 40,000 to 80,000 rows and want to be able to choose to add together a number of those columns to produce another column eg, add columns A,B,F,G or just A+C (so that A1 would get added to C1, A2 added to C2....). I could simply create a new column for each of the permutations but would rather be able to specify which columns I am interested in and have the sheet reflect that choice.

Any advice on how to go about it would be appreciated.

Thanks
nicksoph

 

[steve the fish]

Don't know if its best way but it will work. Putting your columns to sum in V1:Y1 ie A B C D or A D F

=IFERROR(SUM(IFERROR(INDIRECT($V$1&ROW()),0),IFERROR(INDIRECT($W$1&ROW()),0),IFERROR(INDIRECT($X$1&ROW()),0),IFERROR(INDIRECT($Y$1&ROW()),0)),0)

 

[nicksoph]

Hi Steve, that does exactly what was needed.
Many thanks,
n