Prev: Match 2 fields in 2 seperate Spreadsheets and fill another column
Next: subtotal groupings not appearing to the left of the row numbers?
From: nitengale on 23 Mar 2010 15:13
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.


From: Luke M on 23 Mar 2010 15:45
=SUMIF('Sheet 1'!B:B,1,'Sheet 1'!C:C)

--
Best Regards,

Luke M
"nitengale" <nitengale(a)discussions.microsoft.com> wrote in message
news:2E7A195E-B5C0-44E3-BC59-CECC40D8DC79(a)microsoft.com...
> 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.
>
>


From: trip_to_tokyo on 23 Mar 2010 15:49
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.
>
>
From: nitengale on 23 Mar 2010 16:36
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" <nitengale(a)discussions.microsoft.com> wrote in message
> news:2E7A195E-B5C0-44E3-BC59-CECC40D8DC79(a)microsoft.com...
> > 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.
> >
> >
>
>
> .
>
 | 
Pages: 1
Prev: Match 2 fields in 2 seperate Spreadsheets and fill another column
Next: subtotal groupings not appearing to the left of the row numbers?