Excel Forum

Excel Magic Trick 297: Add Certain Column Only

See how to select varying columns for summing adding with:
1.OFFSET function
2.INDIRECT function
3.INDEX function
We will see that the INDEX method with a zero in the row_num is most efficient when calculating speed is taken into consideration.

Got a Question? Ask it Here in the Forum.