=SUMIF('Sheet 1'!B:B,1,'Sheet 1'!C:C)

--
Best Regards,

Luke M
"nitengale" wrote in message
...
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.