What is the best way to add a sum in Worksheet #2 for a range of data in
Worksheet #1.

Example.

Worksheet #1

Date Week # $$
1/1/10 1 10.00
1/2/10 1 10.00
1/3/10 1 10.00


Worksheet #2

Week $$ Total
1 30.00 (looking for a formula to populate this field)

Thanks.