Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Formula Help Last One Please!!

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ok I Want The Following Cells To Add Up

    G18,G18,G19,G20,G21,G22,G23,G24,G25,G26,G27,G28 Then I Want Them To Be Multiplied By 0.2 And I Want That Result Added To Them

    Eg

    20
    20
    20
    20
    20+
    ---
    100x0.2=20

    100+20=120

    that is the sort of result I want

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You're taking the **** with this one aren't you?

    Do you really want G18 summed twice or was that a typo?

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    typo my bad sorry

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Morrissey,

    Are you looking for just the following?

    =1.2*sum(G18:G28)

    Adam

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank Yopu Very Much I Love You

    Moz

  6. #6
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey, send some love my way man.

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I love you too

  8. #8
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    I assume that you meant G17 as the first item, rather than G18.

    The following routine assigns the value you want to the variable "sum_em_up."

    ----------
    Sub add_em()
    Dim sum_em_up As Double
    Dim SumRng As Range

    Set SumRng = Range("G17:G28")
    sum_em_up = WorksheetFunction.Sum(SumRng) * 1.2
    MsgBox sum_em_up

    End Sub
    ----------------

    Bye,
    Jay

  9. #9
    Board Regular
    Join Date
    Mar 2002
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Jay its done now!

Some videos you may like

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
  •