This is optimized for shortness:

=M3 + SUMPRODUCT(Fee, MMULT(--(ID=Y3:AC3),{1;1;1;1;1;1}))

Using your actual ranges:

=M3 + SUMPRODUCT(M$3:M$948, MMULT(--(A$3:A$948=Y3:AC3),{1;1;1;1;1;1}))

Notice there must be as many 1's in the last array as columns in the
Sibling fields, and the 1's are separated by semicolons. The "--"
converts calculated True/False values to 1's and 0's. The other
suggested formulas might refresh faster.

- David Hilberg

On Jul 13, 6:08 am, yshridhar
wrote:
I maintain my school data in excel. Column A is the ID nos of the students.
Column M contians respective Fee amounts. In columns y, z, aa, ab, ac We
maintian the sibling's IDs. We calculate the total amount of all the
siblings to pay in a column. The following is the formula we are using
IF(LEN($Y3)1,SUM(OFFSET($M$1,MATCH($Y3,$A$2:$A$94 8,0),0,1,1))+SUM(OFFSET($M$1,MATCH($Z3,$A$2:$A$948 ,0),0,1,1))+SUM(OFFSET($M$1,MATCH($AA3,$A$2:$A$948 ,0),0,1,1))+SUM(OFFSET($M$1,MATCH($AB3,$A$2:$A$948 ,0),0,1,1))+SUM(OFFSET($M$1,MATCH($AC3,$A$2:$A$948 ,0),0,1,1)),0)
It works well. Can anyone please suggest me a simple procedure for it