There are ways to do this through code, but first, would a subtotal work?
sort by name then do a data-subtotals at each change in name sum errors.
Then hit the little 2 button at the top left of the screen and it will show
error totals
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Jo Fox" wrote:

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