Another formula!

Discussion in 'Microsoft Office Specialist (MOS), Office 365' started by Rosy, Jul 18, 2003.

  1. Rosy
    Honorary Member

    Rosy Megabyte Poster

    665
    1
    54
    I am trying to add a section of numbers up to then take the answer away from a number (which is an absolute cell reference) and so have been trying formulas similar to the following only to keep getting #VALUE! come up

    =SUM($G$5-(H9:J9))

    I'm sure that the answer to this one is simple but I've been staring at it for so long now that I can't do it! :oops:

    Help!
     
    Certifications: MOS Master Instructor
  2. SimonV
    Honorary Member

    SimonV Petabyte Poster Gold Member

    6,651
    180
    258
    I would have thought =SUM(H9:J9)-$G$5 would be better.

    HTH
     
    Certifications: MOS Master 2003, CompTIA A+, MCSA:M, MCSE
    WIP: Keeping CF Alive...
  3. Rosy
    Honorary Member

    Rosy Megabyte Poster

    665
    1
    54
    No because that does the answer take the original figure and I need to do the figure minus the answer!

    EG I need to do 24 ($G$5) - 2+7+8 (H9:J9) so it should equal 7 - the suggestion given gives me -7.
     
    Certifications: MOS Master Instructor
  4. SimonV
    Honorary Member

    SimonV Petabyte Poster Gold Member

    6,651
    180
    258
    Sorry read the question wrong :roll: . Try =$G$5-SUM(H9:J9)
     
    Certifications: MOS Master 2003, CompTIA A+, MCSA:M, MCSE
    WIP: Keeping CF Alive...
  5. Rosy
    Honorary Member

    Rosy Megabyte Poster

    665
    1
    54
    Will try that on Monday but it looks about right! I nearly got it right!!! :wink:

    I award you 5 whole points!! :)
     
    Certifications: MOS Master Instructor

Share This Page

Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.