Summing values of same names

[Gaurav]

Hi,

I get a report everyday. It has a list of all the names in column A and some
values in columns B and C. I paste this report on Sheet2 of a workbook which
has names of my team members on Sheet1. The report that I get might (or
might not) have the names repeated based on the queues the person worked on.
For example if one of my team members worked on more than one Queues, the
report will have his/her name and the values in column B and C twice or
thrice.

In Sheet1, I want to return the total value for that particular name. If the
name appears once, simply return the corresponding values from B and C (this
can easily be done by VLOOKUP) But if the name appears more than once,
return the SUM of all the values corresponding to that name.

I hope the question is clear and understandable.

Thanks

 

[dleo]

Couldn't you just use an IF statement?

 

[Pete_UK]

Have you looked at SUMIF? With your names in column A of Sheet1, put
this in B1:

=SUMIF(Sheet2!$A:$A,$A1,Sheet2!B:B)

Copy it into C1, then copy B1:C1 down to cover your names in column A.

Hope this helps.

Pete

 

[Gaurav]

Man...I am really out of touch. Thanks a ton Pete.


Have you looked at SUMIF? With your names in column A of Sheet1, put
this in B1:

=SUMIF(Sheet2!$A:$A,$A1,Sheet2!B:B)

Copy it into C1, then copy B1:C1 down to cover your names in column A.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete