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

Couldn't you just use an IF statement?

"Gaurav" wrote:

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

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

On Feb 26, 6:20*pm, "Gaurav" wrote:
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

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


"Pete_UK" wrote in message
...
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

On Feb 26, 6:20 pm, "Gaurav" wrote:
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

You're welcome - thanks for feeding back.

Pete

On Feb 27, 8:47*pm, "Gaurav" wrote:
Man...I am really out of touch. Thanks a ton Pete.