+ Reply to Thread
Results 1 to 3 of 3

Substracting numbers in non contigous cells

  1. #1

    Substracting numbers in non contigous cells

    Hi!
    I need a formula to substract numbers in non contigous cells THAT ARE
    IN ONE COLUMN and have the result in other cell, for example:


    ..=2E.....................A...................B

    R1..................................BLANKCELL
    R2..................................BLANKCELL
    R3..................................15
    R4..................................BLANKCELL
    R5..................................BLANKCELL
    R6..................60.............75
    R8..................................BLANKCELL
    R9..................................BLANKCELL
    R10................................BLANKCELL
    R11................................BLANKCELL
    R12................................BLANKCELL
    R13................................BLANKCELL
    R14..............175.............250
    R15................................BLANK
    R16................................BLANK
    R17................................BLANK
    R18................................BLANK
    R19..............50...............300


    Any help will be appreciated

    Thanks and regards

    Guillermo Padr=F3n


  2. #2
    º¼ÖÝÈË
    Guest

    Re: Substracting numbers in non contigous cells

    B1==IF(ISBLANK(A1),"",SUM($A$1:A1))
    and copy formula drop down



  3. #3
    Registered User
    Join Date
    03-21-2005
    Posts
    5

    Smile

    Ok.
    IŽll try it.
    Thanks a lot!
    I appreciate your time and help
    Best regards

+ 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