Results 1 to 4 of 4
Thread: Excel
Hybrid View
-
4th January 2012 09:38 #1Registered 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
-
4th January 2012 09:51 #2
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"
-
4th January 2012 12:38 #3Registered User
Join Date: May:2009
Location: varna
Posts: 14
.
...
=HLOOKUP(A2;Sheet2!$B$1:$E$2;2;1)*(B2+C2 +D2+E2)
-
4th January 2012 13:25 #4




Reply With Quote

7th May 2023, 16:02 in PC