+ Reply to Thread
Results 1 to 3 of 3

Add two sums, take on from the other, then multiply the result by 2. How

  1. #1
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    988

    Add two sums, take on from the other, then multiply the result by 2. How

    Sorry, I know this is really easy but I can't solve it and it's holding me up.

    I've two sums, I need to add both, take one from the other, then double the result.

    SUM(C2:C5) = 10.
    Sum(C6:C7) = 7
    so the result of the following is 3.

    EXCEL =SUM(C2:C5)-SUM(C6:C7)

    I now need to multiply the answer by 2 to get 6 but if I try

    EXCEL =SUM(C2:C5)-SUM(C6:C7)*U2 I get -4

    Where am I going wrong please?
    Last edited by Marvo; 09-04-2021 at 07:19 AM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Add two sums, take on from the other, then multiply the result by 2. How

    Please try this and see

    HTML Code: 

  3. #3
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    988

    Re: Add two sums, take on from the other, then multiply the result by 2. How

    Thank you Bo_Ry, first one worked like a charm.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiply COUNTIFS result by value in next column?
    By dflorian in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-11-2018, 10:42 AM
  2. Replies: 4
    Last Post: 01-10-2014, 09:32 AM
  3. Lookup and Multiply Result
    By StephenSmith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2013, 01:31 PM
  4. Count and multiply the result of checkbox
    By zeez36 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-15-2013, 06:58 AM
  5. Count and multiply the result of checkbox
    By zeez36 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-14-2013, 06:53 AM
  6. Replies: 4
    Last Post: 06-25-2012, 10:38 AM
  7. Multiply result of IF function in same cell
    By rockytop80 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-10-2012, 12:23 PM

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