How do I arrange a formula between cells that are not together?

[Guest]

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

 

[MyVeryOwnSelf]

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)....

One way:
=SUMIF(13:13,"Alison",72:72)

 

[Guest]

Or, if the names are listed in row 13, error counts in row 72, then:
=SUMIF(13:13,"Alison",72:72)

---