Subtract command?
Subtract command?
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Subtract command?

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hello,

    Is there a command like sum which will subtract the values in a range of cells?

    Thank you,
    Denny

  2. #2
    Guest

    Default

    Why not use Sum(A1,-A2) format?
    I can't find Subtract in Excel

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    sum(a1-a2)is good but I want to do a1:a20. Any ideas besides a1-a2-a3 and so.......

    Denny

    [ This Message was edited by: kinkyparamour on 2002-02-23 20:22 ]

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Clovis, NM
    Posts
    334
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This should work. Assume subtracting A2:A20 from A1.

    =A1-SUM(A2:A20)

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    That works great. So simple, why didn't I think of it?

    Thanks again,
    Denny

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com