Results 1 to 25 of 27
Thread: ! Excel. VB
Hybrid View
-
30th October 2009 11:22 #1Registered User
Join Date: Oct:2009
Location: Ruse
Posts: 9
! Excel. VB
:
Sheet1 A1 A2 drop down . .
Sheet 2 , , B .
: , Sheet 1 drop down ( ) B2 Sheet 1 ( ).
, , . .
-
30th October 2009 11:53 #2Registered User
Join Date: Oct:2003
Location:
Posts: 4,317
:
http://www.ozgrid.com/Excel/sum-if.htm
Excel 2007.
-
30th October 2009 12:49 #3Registered User
Join Date: Oct:2009
Location: Ruse
Posts: 9
DSUM, ?!?
---------- 12:49 ---------- 12:02 ----------
, , .Last edited by computerangel; 30th October 2009 at 12:23.
-
30th October 2009 12:51 #4Modderhead
Join Date: Nov:2005
Location:
Posts: 4,469
-
=SUMIF(< >;"<="& ;< >)
-
30th October 2009 13:08 #5Registered User
Join Date: Oct:2009
Location: Ruse
Posts: 9
. , - .
SHEET 2
2-
SHEET 1
: : 39 - 43 39/40/41/42/43 .
-
30th October 2009 13:23 #6Modderhead
Join Date: Nov:2005
Location:
Posts: 4,469
, , , !!!
: <=43 - () <39 . !
-
30th October 2009 14:14 #7Registered User
Join Date: Aug:2009
Location:
Posts: 265
Sheet1, "Weekly" ( F32:G45). Sheet2 C33:C34 Data\Validation, Allow: List, Source: =INDEX(Weekly;;1).
D33 :
- , .Code:=SUM(OFFSET(Weekly;MATCH(C33;INDEX(Weekly;;1);0)-1;1;MATCH(C34;INDEX(Weekly;;1);0)-MATCH(C33;INDEX(Weekly;;1);0)+1;1))
, ("43\9" > "30\10").
-
30th October 2009 16:31 #8Registered User
Join Date: Aug:2009
Location:
Posts: 265
(Weekly )? , ( Evaluate Formula toolbar Formula Auditing). , ( ), Name Box ( ) Enter. MS Excel 2003, .
-
30th October 2009 16:38 #9Registered User
Join Date: Oct:2009
Location: Ruse
Posts: 9
. Avis.
---------- 16:38 ---------- 16:37 ----------
. .
-
31st October 2009 09:19 #10Registered User
Join Date: Oct:2009
Location: Ruse
Posts: 9
.
Range "DB"
, . GA,RZ,RS,SH,SS VT Weekly range-. DB , . .
-
31st October 2009 11:25 #11Registered User
Join Date: Aug:2009
Location:
Posts: 265
, - ( A2:I9) (.. ";1;" ";2;" GA, ";3;" RS ..). , "Weekly" , 0, "INDEX(Weekly;;1)" "W" (W , .. A2:A9). - ("MATCH(" "MATCH($"), - .
-
31st October 2009 12:21 #12Registered User
Join Date: Oct:2009
Location: Ruse
Posts: 9
, VALUE
---------- 12:17 ---------- 12:15 ----------
W GA ?
=SUM(OFFSET(W;MATCH(K5;INDEX(W;;2);0)-1;1;MATCH(K6;INDEX(W;;2);0)-MATCH(K5;INDEX(W;;2);0)+1;1))
---------- 12:21 ---------- 12:17 ----------

=SUM(OFFSET(W;MATCH(K5;INDEX(W;;1);0)-1;2;MATCH(K6;INDEX(W;;1);0)-MATCH(K5;INDEX(W;;1);0)+1;1))
-
5th November 2009 09:09 #13Registered User
Join Date: Oct:2009
Location: Ruse
Posts: 9
:
, . vlookup, .
-
5th November 2009 14:30 #14Registered User
Join Date: Oct:2006
Location: Plovdiv
Posts: 305
: - ..? 4 . , 3 , .
prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?
-
5th November 2009 14:49 #15Registered User
Join Date: Oct:2003
Location:
Posts: 4,317
MS Access?
-
6th November 2009 00:25 #16Registered User
Join Date: Oct:2006
Location: Plovdiv
Posts: 305
asp.net + Mssql php+mysql -
prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?
-
8th November 2009 21:44 #17Registered User
Join Date: Aug:2009
Location:
Posts: 265
/on-topic
vlookup . "W" . :
- ;
- ( );
- ;
- ( );
- , , indirect;
- VBA.
, .
-
25th January 2010 09:11 #18Registered User
Join Date: Oct:2009
Location: Ruse
Posts: 9
:)
, .
. ( ) .
=SUM(OFFSET(raz;MATCH(B233;INDEX(raz;;1) ;0)-1;2;MATCH(C230;INDEX(raz;;1);0)-MATCH(B233;INDEX(raz;;1);0)+1;1))
#n/a. C230 s B233 , , 1 . , .
.
-
26th January 2010 11:41 #19
VLOOKUP. , .
I can be friendly when I desire to. Alas, the desire to be more intelligent does not make it so.
... - :/
-
14th September 2011 14:35 #20Registered User
Join Date: Sep:2010
Location:
Posts: 13
EXCEL 2007
,
:
G2 - ,
, 20-2 , 18
J2 18. , G2 ,
2. , ,
3.
4. C2 - 2 D2 , 1 1,50
vllookup , , - .. .
,
if and, . :
-if(and(D2=),(E2=)),2,if(and(D2= ),(E2=)),1,if(and(D2=),(E2 =)),1,50,0)
, ?
!
Last edited by red_gendo; 16th September 2011 at 09:01.
-
27th September 2011 14:18 #21
-
29th September 2011 15:10 #22Registered User
Join Date: Sep:2010
Location:
Posts: 13




Reply With Quote

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in