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

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

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

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

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

Another thought ..

Using SUMIF might suffice

Assuming the names are listed in col A, error counts in col E
then this in say, G1:
=SUMIF(A:A,"Alison",E:E)
will total Alison's errors
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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

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

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)

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

Or, if the names are listed in row 13, error counts in row 72, then:
=SUMIF(13:13,"Alison",72:72)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---