|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
In a cell on your Summary sheet enter =SUM(Sheet1:Sheet10!G24)
That will give you total of G24 from all sheets.
If the totals are in different cells on each sheet you will have to compound by
entering the = sign in a cell on Summary sheet then switch to sheet1 and
select a cell, then hit + sign, switch to sheet2 and select a cell. hit + sign
Follow this pattern untill you run out of sheets to switch to then hit ENTER
key.
Example formula =Sheet1!G12 + Sheet2!H34 + Sheet3!B23
Gord Dibben MS Excel MVP
On Tue, 6 May 2008 12:06:01 -0700, emgee100 <emgee100@discussions.microsoft.com>
wrote:
>Typing equals, clicking on Sheet 1 and clicking on Sheet 2 isn't working for
>me. I get a '0' in the cell, rather than the text from Sheet 1. Seems like
>the cell should be formatted differently, but I've tried all the options.
>Help!
>
>"David Billigmeier" wrote:
>
>> Type an equals sign in the cell you want the information to end up in, click
>> over to another worksheet, and click on the cell you want to reference.
>> Excel will automatically enter it in.
>>
>> --
>> Regards,
>> Dave
>>
>>
>> "stb" wrote:
>>
>> > I want to link the totals of certain columns of several worksheets to a
>> > summary worksheet in the same workbook. I keep seperate worksheets of the
>> > circulation stats of my library branches, and I want the totals of my columns
>> > to automatically show up on the cumulative worksheet as I enter new circ
>> > figures for each month in the year. Everything I've looked up talks about
>> > linking to different types of Office programs, not something as simple (but
>> > apparently hard to do) as this. Any help greatly appreciated!
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
|
|
| |
I need to transpose cell values (sum) of columns on three spreedsheets so
that the information appears in a single column on the summary sheet within
the same workbook. I have used combinations of = and + signs with $ but with
no luck. Is there a simple command I can use to ahieve the desired result and
allow for subsequent changes to the information on the original spreedsheets?
"Gord Dibben" wrote:
> In a cell on your Summary sheet enter =SUM(Sheet1:Sheet10!G24)
>
> That will give you total of G24 from all sheets.
>
> If the totals are in different cells on each sheet you will have to compound by
> entering the = sign in a cell on Summary sheet then switch to sheet1 and
> select a cell, then hit + sign, switch to sheet2 and select a cell. hit + sign
>
> Follow this pattern untill you run out of sheets to switch to then hit ENTER
> key.
>
> Example formula =Sheet1!G12 + Sheet2!H34 + Sheet3!B23
>
>
> Gord Dibben MS Excel MVP
>
>
> On Tue, 6 May 2008 12:06:01 -0700, emgee100 <emgee100@discussions.microsoft.com>
> wrote:
>
> >Typing equals, clicking on Sheet 1 and clicking on Sheet 2 isn't working for
> >me. I get a '0' in the cell, rather than the text from Sheet 1. Seems like
> >the cell should be formatted differently, but I've tried all the options.
> >Help!
> >
> >"David Billigmeier" wrote:
> >
> >> Type an equals sign in the cell you want the information to end up in, click
> >> over to another worksheet, and click on the cell you want to reference.
> >> Excel will automatically enter it in.
> >>
> >> --
> >> Regards,
> >> Dave
> >>
> >>
> >> "stb" wrote:
> >>
> >> > I want to link the totals of certain columns of several worksheets to a
> >> > summary worksheet in the same workbook. I keep seperate worksheets of the
> >> > circulation stats of my library branches, and I want the totals of my columns
> >> > to automatically show up on the cumulative worksheet as I enter new circ
> >> > figures for each month in the year. Everything I've looked up talks about
> >> > linking to different types of Office programs, not something as simple (but
> >> > apparently hard to do) as this. Any help greatly appreciated!
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
On May 12, 5:37 pm, larc <l...@discussions.microsoft.com> wrote:
> I need to transpose cell values (sum) of columns on three spreedsheets so
> that the information appears in a single column on the summary sheet within
> the same workbook. I have used combinations of = and + signs with $ but with
> no luck. Is there a simple command I can use to ahieve the desired result and
> allow for subsequent changes to the information on the original spreedsheets?
>
> "Gord Dibben" wrote:
> > In a cell on your Summary sheet enter =SUM(Sheet1:Sheet10!G24)
>
> > That will give you total of G24 from all sheets.
>
> > If the totals are in different cells on each sheet you will have to compound by
> > entering the = sign in a cell on Summary sheet then switch to sheet1 and
> > select a cell, then hit + sign, switch to sheet2 and select a cell. hit + sign
>
> > Follow this pattern untill you run out of sheets to switch to then hit ENTER
> > key.
>
> > Example formula =Sheet1!G12 + Sheet2!H34 + Sheet3!B23
>
> > Gord Dibben MS Excel MVP
>
> > On Tue, 6 May 2008 12:06:01 -0700, emgee100 <emgee...@discussions.microsoft.com>
> > wrote:
>
> > >Typing equals, clicking on Sheet 1 and clicking on Sheet 2 isn't working for
> > >me. I get a '0' in the cell, rather than the text from Sheet 1. Seems like
> > >the cell should be formatted differently, but I've tried all the options.
> > >Help!
>
> > >"David Billigmeier" wrote:
>
> > >> Type an equals sign in the cell you want the information to end up in, click
> > >> over to another worksheet, and click on the cell you want to reference.
> > >> Excel will automatically enter it in.
>
> > >> --
> > >> Regards,
> > >> Dave
>
> > >> "stb" wrote:
>
> > >> > I want to link the totals of certain columns of several worksheets to a
> > >> > summary worksheet in the same workbook. I keep seperate worksheets of the
> > >> > circulation stats of my library branches, and I want the totals of my columns
> > >> > to automatically show up on the cumulative worksheet as I enter new circ
> > >> > figures for each month in the year. Everything I've looked up talks about
> > >> > linking to different types of Office programs, not something as simple (but
> > >> > apparently hard to do) as this. Any help greatly appreciated!
You should start your own thread. Also, transpose means to move from
columns to rows. I don't think that is what you want to do.
Are you trying to just get a SUM of the columns, or are you trying to
move all the data from each to show in the summary sheet?
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
i have a workbook with several spreadsheets. in each row on each spreadsheet
there is a sku, upc, description, empty cell to enter floor count (we'll call
this A), empty cell to enter backroom count (we'll call this B), empty cell
to enter system count (we'll call this C), cell that automatically calculates
the difference between the system count and the combined totals of floor and
backroom counts (D= C-(A+B)).
what i need it to do is- if D is more or less than 0, i want that whole ROW
copied to a blank spreadsheet at the end of my workbook. so far, i have only
been able to get it to copy the first cell from that row, but i need the
whole thing. is there a way to do this other than putting a formula in each
row in that column??? thanks, i hope i explained this well.
"Spiky" wrote:
> On May 12, 5:37 pm, larc <l...@discussions.microsoft.com> wrote:
> > I need to transpose cell values (sum) of columns on three spreedsheets so
> > that the information appears in a single column on the summary sheet within
> > the same workbook. I have used combinations of = and + signs with $ but with
> > no luck. Is there a simple command I can use to ahieve the desired result and
> > allow for subsequent changes to the information on the original spreedsheets?
> >
> > "Gord Dibben" wrote:
> > > In a cell on your Summary sheet enter =SUM(Sheet1:Sheet10!G24)
> >
> > > That will give you total of G24 from all sheets.
> >
> > > If the totals are in different cells on each sheet you will have to compound by
> > > entering the = sign in a cell on Summary sheet then switch to sheet1 and
> > > select a cell, then hit + sign, switch to sheet2 and select a cell. hit + sign
> >
> > > Follow this pattern untill you run out of sheets to switch to then hit ENTER
> > > key.
> >
> > > Example formula =Sheet1!G12 + Sheet2!H34 + Sheet3!B23
> >
> > > Gord Dibben MS Excel MVP
> >
> > > On Tue, 6 May 2008 12:06:01 -0700, emgee100 <emgee...@discussions.microsoft.com>
> > > wrote:
> >
> > > >Typing equals, clicking on Sheet 1 and clicking on Sheet 2 isn't working for
> > > >me. I get a '0' in the cell, rather than the text from Sheet 1. Seems like
> > > >the cell should be formatted differently, but I've tried all the options.
> > > >Help!
> >
> > > >"David Billigmeier" wrote:
> >
> > > >> Type an equals sign in the cell you want the information to end up in, click
> > > >> over to another worksheet, and click on the cell you want to reference.
> > > >> Excel will automatically enter it in.
> >
> > > >> --
> > > >> Regards,
> > > >> Dave
> >
> > > >> "stb" wrote:
> >
> > > >> > I want to link the totals of certain columns of several worksheets to a
> > > >> > summary worksheet in the same workbook. I keep seperate worksheets of the
> > > >> > circulation stats of my library branches, and I want the totals of my columns
> > > >> > to automatically show up on the cumulative worksheet as I enter new circ
> > > >> > figures for each month in the year. Everything I've looked up talks about
> > > >> > linking to different types of Office programs, not something as simple (but
> > > >> > apparently hard to do) as this. Any help greatly appreciated!
>
> You should start your own thread. Also, transpose means to move from
> columns to rows. I don't think that is what you want to do.
>
> Are you trying to just get a SUM of the columns, or are you trying to
> move all the data from each to show in the summary sheet?
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
I'm new, so might do some things wrong; just let me know if I do. MY problem:
I work for a non-profit organization that uses a lot of volunteers. The
organization wishes to keep up with all hours of each volunteer with a total
for each week, month, year for each volunteer. I've created a spreadsheet
with 5 worksheets, one for each week of the month and a 6th sheet for monthly
totals for individuals. The first sheet has columns:
A=volunteer ID
B=Volunteer name
C=date
D=time in
E=time out
F=total time
G=volunteer function
G=time in
I=time out
J=total time
K=volunteer function
L=total time (adding F and J)
The monthly sheet has:
A=volunteer ID
B=volunteer name
C=total of first week (to be carried forward from "L" )
D=total of second week
E=total of third week
F=total of fourth week
G=toatl of fifth week (when one exists)
H=sum of all weeks for the month
A part of the problem is that each volunteer comes in, signs in on the next
available row in the sheet for that week, using his/her ID num and name,
which will not be in numerical order, but needs to be carried forward to the
monthly sheet to the right name for calculating time.
Can this be done? If so, how?
Thanks in advance.
Bill
--
Bill HH
"nso" wrote:
> i have a workbook with several spreadsheets. in each row on each spreadsheet
> there is a sku, upc, description, empty cell to enter floor count (we'll call
> this A), empty cell to enter backroom count (we'll call this B), empty cell
> to enter system count (we'll call this C), cell that automatically calculates
> the difference between the system count and the combined totals of floor and
> backroom counts (D= C-(A+B)).
>
> what i need it to do is- if D is more or less than 0, i want that whole ROW
> copied to a blank spreadsheet at the end of my workbook. so far, i have only
> been able to get it to copy the first cell from that row, but i need the
> whole thing. is there a way to do this other than putting a formula in each
> row in that column??? thanks, i hope i explained this well.
>
> "Spiky" wrote:
>
> > On May 12, 5:37 pm, larc <l...@discussions.microsoft.com> wrote:
> > > I need to transpose cell values (sum) of columns on three spreedsheets so
> > > that the information appears in a single column on the summary sheet within
> > > the same workbook. I have used combinations of = and + signs with $ but with
> > > no luck. Is there a simple command I can use to ahieve the desired result and
> > > allow for subsequent changes to the information on the original spreedsheets?
> > >
> > > "Gord Dibben" wrote:
> > > > In a cell on your Summary sheet enter =SUM(Sheet1:Sheet10!G24)
> > >
> > > > That will give you total of G24 from all sheets.
> > >
> > > > If the totals are in different cells on each sheet you will have to compound by
> > > > entering the = sign in a cell on Summary sheet then switch to sheet1 and
> > > > select a cell, then hit + sign, switch to sheet2 and select a cell. hit + sign
> > >
> > > > Follow this pattern untill you run out of sheets to switch to then hit ENTER
> > > > key.
> > >
> > > > Example formula =Sheet1!G12 + Sheet2!H34 + Sheet3!B23
> > >
> > > > Gord Dibben MS Excel MVP
> > >
> > > > On Tue, 6 May 2008 12:06:01 -0700, emgee100 <emgee...@discussions.microsoft.com>
> > > > wrote:
> > >
> > > > >Typing equals, clicking on Sheet 1 and clicking on Sheet 2 isn't working for
> > > > >me. I get a '0' in the cell, rather than the text from Sheet 1. Seems like
> > > > >the cell should be formatted differently, but I've tried all the options.
> > > > >Help!
> > >
> > > > >"David Billigmeier" wrote:
> > >
> > > > >> Type an equals sign in the cell you want the information to end up in, click
> > > > >> over to another worksheet, and click on the cell you want to reference.
> > > > >> Excel will automatically enter it in.
> > >
> > > > >> --
> > > > >> Regards,
> > > > >> Dave
> > >
> > > > >> "stb" wrote:
> > >
> > > > >> > I want to link the totals of certain columns of several worksheets to a
> > > > >> > summary worksheet in the same workbook. I keep seperate worksheets of the
> > > > >> > circulation stats of my library branches, and I want the totals of my columns
> > > > >> > to automatically show up on the cumulative worksheet as I enter new circ
> > > > >> > figures for each month in the year. Everything I've looked up talks about
> > > > >> > linking to different types of Office programs, not something as simple (but
> > > > >> > apparently hard to do) as this. Any help greatly appreciated!
> >
> > You should start your own thread. Also, transpose means to move from
> > columns to rows. I don't think that is what you want to do.
> >
> > Are you trying to just get a SUM of the columns, or are you trying to
> > move all the data from each to show in the summary sheet?
> > |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
Question
Answer
Notify me of replies