Nebu

Hi Nebu -
I kind of ran into a wall when trying to copy the same formula for the team winners.
On the attached file - on Column A82-A85 of the tab "Sparks-Winner" please advise why the formula is not picking up Team Green even though it has the same score as Team Blue?
My apologies for repeated posts on this topic but hopefully this will be my last request for this thread.

Happy Birthday Nebu
Many Returns of the Day...

Regards,

Hi Nebu,

Let me just explain this way then:
=SUMIFS("'"&Reference&"'"!A:A,"'"&Reference&"'"!B:B,A20,"'"&Reference&"'"!C:C,Reference)

Reference is a "Name" changes in real time based on a List selection. I get an error in this. Any help is appreciated.

Regards,
Chine

Hi Nebu,

Trust you are well & doing good. Last week I participated in an Excel competition & met this peculiar problem.

Mentioned below is the link.
http://chandoo.org/forum/threads/need-help-on-this-assignment-i-found-this-in-web.28257/
Need your expertise as always

Rgds,

Simayan

Hi Nebu pls tell me if i can donate to you?

HI Nebu. Sorry to write here and bother you. I had an additional query on an earlier post you helped me with. Are you able to assist me again. Thanks in advance
http://forum.chandoo.org/threads/formula-to-pick-value-from-1-cell-and-fill-in-other-cells-upto-the-value-in-first-cell.23272/#post-140941

Congrats Nebu for the New Trophy
Keep sharing your wealth of knowledge with us.