+ Reply to Thread
Results 1 to 4 of 4

SUM of range..Except

  1. #1
    Forum Contributor
    Join Date
    02-10-2007
    MS-Off Ver
    Excel 2010
    Posts
    291

    SUM of range..Except

    Hi,

    Does anyone know if its possible to do a sum of a range, with an exception

    Example

    I want to sum cells a2..a10, except cell a9

    thanks in advance for any help.

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    This might be basic for your application, but you can always do something like:

    =SUM(A1:A10)-A9

    Let me know if that helps.

  3. #3
    Forum Contributor
    Join Date
    02-10-2007
    MS-Off Ver
    Excel 2010
    Posts
    291
    yep thanks for your help.

    i appreciate it.

  4. #4
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Glad I could help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1