|
Featured Tutorial
Featured Macro
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.
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.