Respected experts I have a sheet where against some voucher numbers I typed name of employee who have entered it wrongly and then I put a fine amount against this .And you know that names may repeat again and again for different vouchers .then I have another section of the sheet where I have names of all the employees and now I want excel to sum only the amount of fine for each employees who have committed mistakes.can anyone help me in this regard .problem is that I the names are actually got from a reference because employee can be changed.
Bookmarks