Results 1 to 4 of 4

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: May:2009
    Location: varna
    Posts: 14

    Excel

    ,
    Excel.

    1 . 2 , 2 1 .

    "14" 1, 2 1.
    14- 1 14- 2 691,39. 1, 100 000. 69 139 000 . .


    .
    zadachka.zip

  2. #2
    feersum's Avatar
    Join Date: Dec:2009
    Location:
    Posts: 4,103
    sheet 2 , sheet 1? ?

    , sheet 2 Transpose sheet 3.

    F () :
    =(SUM(B2:E2)*VLOOKUP(A:A;Sheet3!A:B;2;FA LSE))

    (SUM), B , .

    :
    69139.000
    5580.375
    5580.375
    41483.400
    10774.050
    744.050
    26935.125
    784.300
    1960.750

    14 (69 139 000), 69 139

    :
    HLOOKUP, transpose- sheet 2:
    =(SUM(B2:E2)*HLOOKUP(A2;Sheet2!$1:$2;2;F ALSE))

    Last edited by feersum; 4th January 2012 at 10:08.
    "Comin' in on a wing and a prayer, Comin' in on a wing and a prayer, With our one motor gone, We can still carry on, Comin' in on a wing and a prayer"

  3. #3
    Registered User
    Join Date: May:2009
    Location: varna
    Posts: 14
    .

    ...

    =HLOOKUP(A2;Sheet2!$B$1:$E$2;2;1)*(B2+C2 +D2+E2)

  4. #4
    feersum's Avatar
    Join Date: Dec:2009
    Location:
    Posts: 4,103
    Quote Originally Posted by bobibene View Post
    .

    ...

    =HLOOKUP(A2;Sheet2!$B$1:$E$2;2;1)*(B2+C2 +D2+E2)
    SUM(B2:E2) (B2+C2+D2+E2) .

    - , .
    "Comin' in on a wing and a prayer, Comin' in on a wing and a prayer, With our one motor gone, We can still carry on, Comin' in on a wing and a prayer"

Posting Permissions

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

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |