Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel Magic Trick 297: Add Certain Column Only

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
4,122
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Mar 23, 2009

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.

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (2)

Sign In or Sign Up now to post a comment!
  • Dear vsramesh45,

    Thanks!

    --excelisfun

  • vazgha valamudan

  • From comment above

    Dear dnorton4444,

    Then watch the Playlist in this order:

    01 Excel Basics Series: The Story Of Excel!

    02 Excel Series: Lookup functions

    03 The Beauty Of Excel

    Then just continue in the numbered order

    --excelisfun

  • Dear dnorton4444,

    Feeling lost is a great starting point!! That means you are about to learn a lot of cool new things! As for as the excelisfun channel helping, watch this video to see how to use the channel (search for this and then watch it):

    Search For Excel Videos Download Excel Workbooks excelisfun

    --excelisfun

    More in next comment

  • I have used Excel for years but feel lost. Where should I start, I use both Mac 2008 and MSO 2007.

    Thanks,

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more