dabenxiang12
05-18-2008, 06:48 AM
two tables,tabel a:
index name product
1 x x
2 u u
table b:
index property map content
1 1 1 2
2 2 1 3
3 1 2 2
question1:records in table a is connected with records in table b through the segement map(map in table b directs table a's index),for the example,the first record in table a connects withs the first two records in table b,the second record in table connects with the third record in table b,now i want to count the number of records in table a on condition that the property of any record in table b which is connected with the records in table a is 1,then the record in table a is counted.through this algorithm,the result of the question is 2,how to write the excel function .
question 2:from the first record to the last record in table a,i want to sum up the content of all the records in table b connected with the record in table a ,the result of the question is :the first record in table a:3+2=5
the second record in table b:2
how to write the excel formula,
hurry ,please help me!
index name product
1 x x
2 u u
table b:
index property map content
1 1 1 2
2 2 1 3
3 1 2 2
question1:records in table a is connected with records in table b through the segement map(map in table b directs table a's index),for the example,the first record in table a connects withs the first two records in table b,the second record in table connects with the third record in table b,now i want to count the number of records in table a on condition that the property of any record in table b which is connected with the records in table a is 1,then the record in table a is counted.through this algorithm,the result of the question is 2,how to write the excel function .
question 2:from the first record to the last record in table a,i want to sum up the content of all the records in table b connected with the record in table a ,the result of the question is :the first record in table a:3+2=5
the second record in table b:2
how to write the excel formula,
hurry ,please help me!