Excel Forum
Similar Content
Automatically Lock Certain Cells in Excel using a Macro
Tutorial: This macro allows you to have a cell automatically locked after a user enters something in...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Sum Values that Equal 1 of Many Conditions across Multiple Columns in Excel
Tutorial: How to Sum values using an OR condition across multiple columns, including using OR with ...



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.