Summarize a range referenced in a separate worksheet

[nitengale]

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.

 

[Luke M]

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

 

[trip_to_tokyo]

EXCEL 2007

1. In Sheet1 cell C 5 I have:-

=SUM(C2:C4)

This gives your 30.00 total.

2. In Sheet2 cell C 5 (or any cell you like) I have:-

=Sheet1!C5

This just brings in the 30.00 total from Sheet1 cell C 5.

If my comments have helped please hit Yes.

Thanks.

 

[nitengale]

I'm having a problem with this formula when I attempt to copy it down (on
sheet #2 I have 52 weeks and don't want to have to change the week # in each
cell)?