Khawaja Saab

you can do the following almighty sumif formula in column A6. I am assuming
that the A1 (unique ids) are not repeated in sheet1 and that the ids may be
repeated in sheet2-5.

=SUMIF(Sheet2!$A$2:$A$22500,Sheet1!A2,Sheet2!$D$2: $D$22500)+SUMIF(Sheet3!$A$2:$A$22500,Sheet1!A2,She et3!$D$2:$D$22500)+SUMIF(Sheet4!$A$2:$A$22500,Shee t1!A2,Sheet4!$D$2:$D$22500)+SUMIF(Sheet5!$A$2:A6,S heet1!A2,Sheet5!$D$2:$D$22500)




"Khawajaanwar" wrote:

In worksheet in sheet-1 I have about 15,000 rows in the following columns
A1(Unique id)
A2 Names of persons
A3 Address
A4 Amount for the year 2005
A5 Amount for the year 2006
A6 Amount for the year 2007 (Blank / no date)

In sheet-2 I have 22,500 rows and have following columns
A1 (Unique id)
A2 Names of person
A3 Address
A4 Amount for the year 2007

Same above column in sheet-3, sheet-4 and sheet-5
I have to update the rows of column A6 of sheet 1 through column A4 of
sheet-2, sheet-3, sheet-4 and sheet-5

Please help to filter the data