I need to sum rows in excel.
But there are rows with duplicate data..
e.g If for a giveb two rows.. with column FileName
If the number  appears in Row 1 and row 2.
Only one row 1 will be calculate. Row two will be skipped.
This case may involve about 4 rows.. Hence only 1 row out of the 4 will be included in the calculation..