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.