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

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

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