Summarize a range referenced in a separate worksheet
 

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.

Summarize a range referenced in a separate worksheet
 

=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.

Summarize a range referenced in a separate worksheet
 

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" wrote:

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.

Summarize a range referenced in a separate worksheet
 

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)?

"Luke M" wrote:

=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.




.