dear sir, i have data in two column B and E on sheet 2 I wanted the amount using sumif on the basis of Number as eg mentioned in the sheet. Thanks.