VLOOKUP with duplicate table array value

[paolo03]

Dear excel masters,
I have a table of names and dates, the left table names has duplicate value. I need to summarize the table to sum all the name values at specific dates.
As we know vlookup only count the first name it finds.
How can i fill the summarized table?
Thank you in advance.

 

[Fluff]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=SUMPRODUCT((Sheet1!$A$2:$A$20=$A2)*(Sheet1!$B$1:$J$1=B$1),Sheet1!$B$2:$J$20)

 

[paolo03]

I figured it out, it's just a sumifs problem, silly me

 

[paolo03]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=SUMPRODUCT((Sheet1!$A$2:$A$20=$A2)*(Sheet1!$B$1:$J$1=B$1),Sheet1!$B$2:$J$20)

Thank you

 

[Fluff]

Glad to help & thanks for the feedback.