where your summary data is on Page2 B1:G2 and your received data is on Page 1
A2:C8, try this in cell D2 and copy down.

=MEDIAN(B2,0,HLOOKUP(A2,'Page 2'!$B$1:$G$2,2,0)-SUMIF(A$2:A2,A2,B$2:B2)+B2)

"vmohan1978" wrote:

Page 2 (summary)
RAB No CERTIFIED QUANTITY OF STEEL IN MT
8mm 10mm 12mm 16mm 20mm 25mm

Sum 13.698 - - 49.710 109.236 -


Page 1
Received Dia Qty Rate difference

16 25 15000 25.00(forumla required)
16 42.5 12000 24.71it should shows(49.710-25) sa same dia
8 11 13000 11(it should show)
20 25.00 10250
8 8.50 11500 2.698(13.698-11( which is same dia as above)
20 16.37 13500
8 5.00 14800


summary may not necessary to be in Page-2 it may in page1 also

if not understood i will send my excel sheet please send me the e-mail id
my email id is