I am trying to set up a spreadsheet that is quite complicated and I'm not
sure if it can be done. Basically it is based on an audit sheet, with the
names in Row 13 and the amount of errors in Row 72 (so for example it will
show Alison in Row 13 and then in Row 72 it will show 5). What I'm looking to
do is set up a formula to first search for a name and then see how many
errors that person has (a person may appear more than once in the sheet).
E.g, Alison may have had 4 pieces of work audited so she will appear in the
worksheet 4 times, each will have different amount of errors, so I would like
to know how many errors she has in total. Thanks