+ Reply to Thread
Results 1 to 4 of 4

Help - Sum only 10 cells in each column

  1. 12-26-2012, 03:58 AM #1
    prince316
    prince316 is offline
    Registered User
    Join Date
    12-26-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Help - Sum only 10 cells in each column

    Hi,

    Can any one help me with a formula to sum the values in the attached sheet.

    Regards
    Nrs
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-26-2012, 04:02 AM #2
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Help - Sum only 10 cells in each column

    In B28 try 

    Please Login or Register  to view this content.
    copy across
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  3. 12-26-2012, 04:03 AM #3
    dogberry
    dogberry is offline
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Help - Sum only 10 cells in each column

    Hi

    Highlight the cell you want the answer in and click autosum top right when the marching ants appear going to the left just click in the top cell of your column and drag down.

    Chris
    Click my star if I helped Thanks
    Reply With QuoteRegister To Reply
  4. 12-26-2012, 04:06 AM #4
    prince316
    prince316 is offline
    Registered User
    Join Date
    12-26-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Help - Sum only 10 cells in each column

    Thank a lot for your help, it worked !
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1