G
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!
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!