If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using MATCH or ......?
Hi all of you,
I need your help. I have a sheet with the follwonig data TABLE 1 TABLE 2 INDEX Q'TY PRICE TOTAL INDEX Q'TY TOTAL AVG 1 100 2 200 12 SUM(B3+B4) SUM(D3+D4) 2 200 3 600 13 SUM(B3+B5) SUM(D3+D5) 3 300 4 1,200 14 SUM(B3+B6) SUM(D3+D6) 4 400 5 2,000 15 5 500 6 3,000 23 24 25 34 35 123 SUM(B3+B4+B5) SUM(D3+D4+D6) Problem is to solve as The function in column "Q'TY" in table 2 will lookup the number (value) in colume "INDEX" in table 2 to colume "INDEX" in table 1 then calculate the quantity. In my case as number 12 in colum "INDEX" in table 2 is a combination between number 1 and 2, so SUM(B3+B4) Similarly to the culume "TOTAL" in table 2 Please, anyone can help to solve this function, VBA, or macro Thanks in advance! or you can download file for more understanding mediafire[DOT]com/file/ghqyrj340lb/Book2.zip |
#2
|
|||
|
|||
Using MATCH or ......?
Could you please explain to us what difference you expect between SUM(B3+B4)
and just (B3+B4)? Is there some subtle use of the SUM function of which we are unaware? -- David Biddulph timgiaiphap wrote: Hi all of you, I need your help. I have a sheet with the follwonig data TABLE 1 TABLE 2 INDEX Q'TY PRICE TOTAL INDEX Q'TY TOTAL AVG 1 100 2 200 12 SUM(B3+B4) SUM(D3+D4) 2 200 3 600 13 SUM(B3+B5) SUM(D3+D5) 3 300 4 1,200 14 SUM(B3+B6) SUM(D3+D6) 4 400 5 2,000 15 5 500 6 3,000 23 24 25 34 35 123 SUM(B3+B4+B5) SUM(D3+D4+D6) Problem is to solve as The function in column "Q'TY" in table 2 will lookup the number (value) in colume "INDEX" in table 2 to colume "INDEX" in table 1 then calculate the quantity. In my case as number 12 in colum "INDEX" in table 2 is a combination between number 1 and 2, so SUM(B3+B4) Similarly to the culume "TOTAL" in table 2 Please, anyone can help to solve this function, VBA, or macro Thanks in advance! or you can download file for more understanding mediafire[DOT]com/file/ghqyrj340lb/Book2.zip |
#3
|
|||
|
|||
Using MATCH or ......?
TKS FOR REPLY
SUM(B3+B4) AND SUM(B3+B5) IS MY TARGET FOR A FUNCTION. IN STEADY OF USING SUM FUNCTION I WANT TO LOOK FOR ANOTHER FUNCTION FOR ALL CELL IN SAME COLUME PLS DOWNLOAD FILE TO UNDERSTAND mediafire[DOT]com/file/ghqyrj340lb/Book2.zip David Biddulph wrote: Could you please explain to us what difference you expect between SUM(B3+B4) and just (B3+B4)? Is there some subtle use of the SUM function of which we are unaware? -- David Biddulph Hi all of you, [quoted text clipped - 27 lines] or you can download file for more understanding mediafire[DOT]com/file/ghqyrj340lb/Book2.zip -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200903/1 |
Thread Tools | |
Display Modes | |
|
|