I am planning to store the production details for persons in a excel Sheet.

The Second Row Will(Start from B2---B15) Contain the Name of the Employees.
The Third row will contain one group of operation
and the fourthrow will contain another group of operations. I Have to
calculate the efficiency also.

And in the 7th row has to contain sum of all the values(cumulative) of Third
row and 8 th row has o contain the
of all the values(cumulative) of fourthrow.

Production for the day Effiency For the Day Total

Name Operation1 Operation2
Operation1 Operation2 Effiency



Name 10 10 20% 20 20
50%

How Can I do this one in Excel

Thanks
Dana

Here is the sample Format

Hi Dana

I think you are confusing Columns and Rows.
Columns have Letters
Rows have Numbers

=SUM(C2:C15) will give the total value of the entries you have in column C
(3rd column)
=SUM(D215) will give the total of the entries in column D (4th column)
--

Regards
Roger Govier

"Dana" <(E-Mail Removed)> wrote in message
news:6C96288F-A2E1-4C97-9E35-(E-Mail Removed)...
> I am planning to store the production details for persons in a excel
> Sheet.
>
> The Second Row Will(Start from B2---B15) Contain the Name of the
> Employees.
> The Third row will contain one group of operation
> and the fourthrow will contain another group of operations. I Have to
> calculate the efficiency also.
>
> And in the 7th row has to contain sum of all the values(cumulative) of
> Third
> row and 8 th row has o contain the
> of all the values(cumulative) of fourthrow.
>
> Production for the day Effiency For the Day Total
>
> Name Operation1 Operation2
> Operation1 Operation2 Effiency
>
>
>
> Name 10 10 20% 20 20
> 50%
>
> How Can I do this one in Excel
>
> Thanks
> Dana
>
> Here is the sample Format
>
>

Dear Roger,
Thanks for your reply . I want to do like this

http://www.vbforums.com/showthread.php?t=501013

Thanks
Dana


"Roger Govier" wrote:

> Hi Dana
>
> I think you are confusing Columns and Rows.
> Columns have Letters
> Rows have Numbers
>
> =SUM(C2:C15) will give the total value of the entries you have in column C
> (3rd column)
> =SUM(D215) will give the total of the entries in column D (4th column)
> --
>
> Regards
> Roger Govier
>
> "Dana" <(E-Mail Removed)> wrote in message
> news:6C96288F-A2E1-4C97-9E35-(E-Mail Removed)...
> > I am planning to store the production details for persons in a excel
> > Sheet.
> >
> > The Second Row Will(Start from B2---B15) Contain the Name of the
> > Employees.
> > The Third row will contain one group of operation
> > and the fourthrow will contain another group of operations. I Have to
> > calculate the efficiency also.
> >
> > And in the 7th row has to contain sum of all the values(cumulative) of
> > Third
> > row and 8 th row has o contain the
> > of all the values(cumulative) of fourthrow.
> >
> > Production for the day Effiency For the Day Total
> >
> > Name Operation1 Operation2
> > Operation1 Operation2 Effiency
> >
> >
> >
> > Name 10 10 20% 20 20
> > 50%
> >
> > How Can I do this one in Excel
> >
> > Thanks
> > Dana
> >
> > Here is the sample Format
> >
> >
>

Hi Dana

I don't understand the figures in column E

To get the values for column I
=SUM(C3939)/SUM(G39:H39)
Format the cell I39 Format>Cells>Number>Percentage

--

Regards
Roger Govier

"Dana" <(E-Mail Removed)> wrote in message
news:BD506450-128A-4B8B-B0B3-(E-Mail Removed)...
> Dear Roger,
> Thanks for your reply . I want to do like this
>
> http://www.vbforums.com/showthread.php?t=501013
>
> Thanks
> Dana
>
>
> "Roger Govier" wrote:
>
>> Hi Dana
>>
>> I think you are confusing Columns and Rows.
>> Columns have Letters
>> Rows have Numbers
>>
>> =SUM(C2:C15) will give the total value of the entries you have in column
>> C
>> (3rd column)
>> =SUM(D215) will give the total of the entries in column D (4th column)
>> --
>>
>> Regards
>> Roger Govier
>>
>> "Dana" <(E-Mail Removed)> wrote in message
>> news:6C96288F-A2E1-4C97-9E35-(E-Mail Removed)...
>> > I am planning to store the production details for persons in a excel
>> > Sheet.
>> >
>> > The Second Row Will(Start from B2---B15) Contain the Name of the
>> > Employees.
>> > The Third row will contain one group of operation
>> > and the fourthrow will contain another group of operations. I Have to
>> > calculate the efficiency also.
>> >
>> > And in the 7th row has to contain sum of all the values(cumulative) of
>> > Third
>> > row and 8 th row has o contain the
>> > of all the values(cumulative) of fourthrow.
>> >
>> > Production for the day Effiency For the Day Total
>> >
>> > Name Operation1 Operation2
>> > Operation1 Operation2 Effiency
>> >
>> >
>> >
>> > Name 10 10 20% 20 20
>> > 50%
>> >
>> > How Can I do this one in Excel
>> >
>> > Thanks
>> > Dana
>> >
>> > Here is the sample Format
>> >
>> >
>>

Dear Roger,
The column in E is ((C39+D39)/100)*100. What I want to is, if the
user enters some value
like 10 in the C39, I want to add that value to the G39 and clear the value
in C39. And also Add the value in C40
to H40 and clear the values from C40.How can I?

Dana



"Roger Govier" wrote:

> Hi Dana
>
> I don't understand the figures in column E
>
> To get the values for column I
> =SUM(C3939)/SUM(G39:H39)
> Format the cell I39 Format>Cells>Number>Percentage
>
> --
>
> Regards
> Roger Govier
>
> "Dana" <(E-Mail Removed)> wrote in message
> news:BD506450-128A-4B8B-B0B3-(E-Mail Removed)...
> > Dear Roger,
> > Thanks for your reply . I want to do like this
> >
> > http://www.vbforums.com/showthread.php?t=501013
> >
> > Thanks
> > Dana
> >
> >
> > "Roger Govier" wrote:
> >
> >> Hi Dana
> >>
> >> I think you are confusing Columns and Rows.
> >> Columns have Letters
> >> Rows have Numbers
> >>
> >> =SUM(C2:C15) will give the total value of the entries you have in column
> >> C
> >> (3rd column)
> >> =SUM(D215) will give the total of the entries in column D (4th column)
> >> --
> >>
> >> Regards
> >> Roger Govier
> >>
> >> "Dana" <(E-Mail Removed)> wrote in message
> >> news:6C96288F-A2E1-4C97-9E35-(E-Mail Removed)...
> >> > I am planning to store the production details for persons in a excel
> >> > Sheet.
> >> >
> >> > The Second Row Will(Start from B2---B15) Contain the Name of the
> >> > Employees.
> >> > The Third row will contain one group of operation
> >> > and the fourthrow will contain another group of operations. I Have to
> >> > calculate the efficiency also.
> >> >
> >> > And in the 7th row has to contain sum of all the values(cumulative) of
> >> > Third
> >> > row and 8 th row has o contain the
> >> > of all the values(cumulative) of fourthrow.
> >> >
> >> > Production for the day Effiency For the Day Total
> >> >
> >> > Name Operation1 Operation2
> >> > Operation1 Operation2 Effiency
> >> >
> >> >
> >> >
> >> > Name 10 10 20% 20 20
> >> > 50%
> >> >
> >> > How Can I do this one in Excel
> >> >
> >> > Thanks
> >> > Dana
> >> >
> >> > Here is the sample Format
> >> >
> >> >
> >>

OK, Dana, let us into the secret, please.
What advantage do you get in dividing by 100 then multiplying by 100?
--
David Biddulph

"Dana" <(E-Mail Removed)> wrote in message
news:68319BC2-7160-4179-A97A-(E-Mail Removed)...
> Dear Roger,
> The column in E is ((C39+D39)/100)*100.
....

Sorry for that .There is nothing in that .

"David Biddulph" wrote:

> OK, Dana, let us into the secret, please.
> What advantage do you get in dividing by 100 then multiplying by 100?
> --
> David Biddulph
>
> "Dana" <(E-Mail Removed)> wrote in message
> news:68319BC2-7160-4179-A97A-(E-Mail Removed)...
> > Dear Roger,
> > The column in E is ((C39+D39)/100)*100.
> ....
>
>
>

Any one have some idea ?


"Dana" wrote:

> Sorry for that .There is nothing in that .
>
> "David Biddulph" wrote:
>
> > OK, Dana, let us into the secret, please.
> > What advantage do you get in dividing by 100 then multiplying by 100?
> > --
> > David Biddulph
> >
> > "Dana" <(E-Mail Removed)> wrote in message
> > news:68319BC2-7160-4179-A97A-(E-Mail Removed)...
> > > Dear Roger,
> > > The column in E is ((C39+D39)/100)*100.
> > ....
> >
> >
> >

Some idea about what? The text has been snipped, so there's no hint below as
to your question.

"Dana" <(E-Mail Removed)> wrote in message
news:20D19BF5-2487-466B-94C0-(E-Mail Removed)...
> Any one have some idea ?
>
>
> "Dana" wrote:
>
>> Sorry for that .There is nothing in that .
>>
>> "David Biddulph" wrote:
>>
>> > OK, Dana, let us into the secret, please.
>> > What advantage do you get in dividing by 100 then multiplying by 100?
>> > --
>> > David Biddulph
>> >
>> > "Dana" <(E-Mail Removed)> wrote in message
>> > news:68319BC2-7160-4179-A97A-(E-Mail Removed)...
>> > > Dear Roger,
>> > > The column in E is ((C39+D39)/100)*100.
>> > ....
>> >
>> >
>> >

Any idea for my question in the first Post

"Stephen" wrote:

> Some idea about what? The text has been snipped, so there's no hint below as
> to your question.
>
> "Dana" <(E-Mail Removed)> wrote in message
> news:20D19BF5-2487-466B-94C0-(E-Mail Removed)...
> > Any one have some idea ?
> >
> >
> > "Dana" wrote:
> >
> >> Sorry for that .There is nothing in that .
> >>
> >> "David Biddulph" wrote:
> >>
> >> > OK, Dana, let us into the secret, please.
> >> > What advantage do you get in dividing by 100 then multiplying by 100?
> >> > --
> >> > David Biddulph
> >> >
> >> > "Dana" <(E-Mail Removed)> wrote in message
> >> > news:68319BC2-7160-4179-A97A-(E-Mail Removed)...
> >> > > Dear Roger,
> >> > > The column in E is ((C39+D39)/100)*100.
> >> > ....
> >> >
> >> >
> >> >
>
>
>