If & Lookup & match Formula Required!

[Guest]

I Have 17 work sheets named W1 : W17 each sheet consists a Column H2 that
lists winners Name.

On Summary Page I have the following:

Names from G8 : G47
Totals Each Week from H8: X8 down to H47:X47
The Amount awarded each Week in column H3

What I need is a formula that can read if a number is showing H8:X47 1 or
above that it lookup the winner of that week under Week sheets and add a
dollar amount under that person on the Summary Sheet.

Thanks!

 

[Guest]

If you do "~+ control", it will show all your formulas. Hope that helps!

 

[Guest]

Not sure hopw this will show anything I need to creat a formula listed below...