Sum with vlookup

[clprdctn]

Hello everyone,

You will see the names on column A, those are just the beginning, there will be a lot more added to this spreadsheet. And as the names are added manually their TM name will be added manually as well.

The issue is I don't know how to write the vlookup formula for this. The area is highlighted in Yellow.

Basically I need the Q1, Q2, Q3, Q4 results of Alex V.'s Team.

And Same for David C.

I saw that there is a way to do it with vlooup and by using number of rows to the right of the origin, etc.

Thank you.

[rcm]

Is this helpful?

[clprdctn]

I can't seem to get it to work.

Attachment is the updated one. Basically I'm trying to get the data from another tab("Jan" within the workbook and i tried to change your formula to:

=SUMIF(Jan!$F1:$F1000,'TM View'!$A5,Jan!G12:AK1000)

and it's not working.

[clprdctn]

Sorry for posting again but I have a class very shortly and I really need this for my presentation. Anyone available to help please?

[fribruger]

Hi,

If you are just counting entries by team manager by month you can just sum MTD in col. B


=SUMIF(Jan!$F$1:$F$1000;'TM View'!$A5;Jan!$B$1:$B$1000)

Hope it helps

[clprdctn]

Thank you so much! Works like a charm.

[Fotis1991]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED",as per our Forum Rule #9. I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

[xladept]

Hi,

It looks like you got your answer - but you could do it by VBA also, either by invoking Worksheet Function sum of the range (preferred) or by using an accumulator variable.

'til next time.