1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Another formula!

Discussion in 'Microsoft Office Specialist (MOS)' 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

    SimonV Petabyte Poster Administrator

    6,616
    149
    228
    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

    SimonV Petabyte Poster Administrator

    6,616
    149
    228
    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...