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(D2:D15) will give the total of the entries in column D (4th column)
--

Regards
Roger Govier

"Dana" wrote in message
...
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(D2:D15) will give the total of the entries in column D (4th column)
--

Regards
Roger Govier

"Dana" wrote in message
...
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(C39:D39)/SUM(G39:H39)
Format the cell I39 FormatCellsNumberPercentage

--

Regards
Roger Govier

"Dana" wrote in message
...
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(D2:D15) will give the total of the entries in column D (4th column)
--

Regards
Roger Govier

"Dana" wrote in message
...
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(C39:D39)/SUM(G39:H39)
Format the cell I39 FormatCellsNumberPercentage

--

Regards
Roger Govier

"Dana" wrote in message
...
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(D2:D15) will give the total of the entries in column D (4th column)
--

Regards
Roger Govier

"Dana" wrote in message
...
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" wrote in message
...
Dear Roger,
The column in E is ((C39+D39)/100)*100.
....

This is my question :)

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


Here is the sample Format

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


Dana





"Dana" wrote:

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

Sorry, Dana. I'm not trying to be awkward, but it isn't at all clear from
this how far you have got or what you are having trouble with. Please be
precise about what you are asking. If you have a formula that isn't giving
the result you expect, quote the formula and say what is in the cells to
which it refers. Say what result you get and what you expect. If you don't
know how to write a particular formula, say which cells it will depend on,
what is in them, and (in words) what the relationship is.

If you ask a specific question properly you will likely get a workable
answer. Asking a vague question will not produce much in the way of a useful
reply.

"Dana" wrote in message
...
This is my question :)

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


Here is the sample Format

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


Dana





"Dana" wrote:

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

I believe that Dana has the rows and columns confused also.

"Second row B2:B15" indicates Column B to this reader.

Perhaps Dana could clarify that the word "row" should be "column"?


Gord Dibben MS Excel MVP


On Tue, 18 Dec 2007 14:22:36 -0000, "Stephen" <none wrote:

Sorry, Dana. I'm not trying to be awkward, but it isn't at all clear from
this how far you have got or what you are having trouble with. Please be
precise about what you are asking. If you have a formula that isn't giving
the result you expect, quote the formula and say what is in the cells to
which it refers. Say what result you get and what you expect. If you don't
know how to write a particular formula, say which cells it will depend on,
what is in them, and (in words) what the relationship is.

If you ask a specific question properly you will likely get a workable
answer. Asking a vague question will not produce much in the way of a useful
reply.

"Dana" wrote in message
...
This is my question :)

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


Here is the sample Format

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


Dana





"Dana" wrote:

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 Stephen / Gord,
Thanks for ur spending times on this post.

Please see this image

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


In that screen,
The values in C39 and D39 is of manual Entries. As soon I
enter the value in C39, that value to be added
to G39 and the value in C39 should be cleared.And the Value in the I39 is
=((G39/10)+(H39/10)*100).

Hope I am clear Now

Thanks in Advanace
Danasegarane




"Gord Dibben" wrote:

I believe that Dana has the rows and columns confused also.

"Second row B2:B15" indicates Column B to this reader.

Perhaps Dana could clarify that the word "row" should be "column"?


Gord Dibben MS Excel MVP


On Tue, 18 Dec 2007 14:22:36 -0000, "Stephen" <none wrote:

Sorry, Dana. I'm not trying to be awkward, but it isn't at all clear from
this how far you have got or what you are having trouble with. Please be
precise about what you are asking. If you have a formula that isn't giving
the result you expect, quote the formula and say what is in the cells to
which it refers. Say what result you get and what you expect. If you don't
know how to write a particular formula, say which cells it will depend on,
what is in them, and (in words) what the relationship is.

If you ask a specific question properly you will likely get a workable
answer. Asking a vague question will not produce much in the way of a useful
reply.

"Dana" wrote in message
...
This is my question :)

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


Here is the sample Format

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


Dana





"Dana" wrote:

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

It is now clear that you require a macro, as you want the event of entering
a value into C39 to trigger a single recalculation of the accumulated sum in
G39 (and also to clear C39). Some people here may be able to help with this,
but I'm not one of them. I hope you get an answer from someone else.

(I'm not comfortable with being unable to see where a result has come from.
I would never remember whether I had added in a particular day's production
or not. My preferred approach would be to make a list of production for each
day, with a formula to calculate the total.)

"Dana" wrote in message
...
Dear Stephen / Gord,
Thanks for ur spending times on this post.

Please see this image

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


In that screen,
The values in C39 and D39 is of manual Entries. As soon I
enter the value in C39, that value to be added
to G39 and the value in C39 should be cleared.And the Value in the I39 is
=((G39/10)+(H39/10)*100).

Hope I am clear Now

Thanks in Advanace
Danasegarane




"Gord Dibben" wrote:

I believe that Dana has the rows and columns confused also.

"Second row B2:B15" indicates Column B to this reader.

Perhaps Dana could clarify that the word "row" should be "column"?


Gord Dibben MS Excel MVP


On Tue, 18 Dec 2007 14:22:36 -0000, "Stephen" <none wrote:

Sorry, Dana. I'm not trying to be awkward, but it isn't at all clear
from
this how far you have got or what you are having trouble with. Please be
precise about what you are asking. If you have a formula that isn't
giving
the result you expect, quote the formula and say what is in the cells to
which it refers. Say what result you get and what you expect. If you
don't
know how to write a particular formula, say which cells it will depend
on,
what is in them, and (in words) what the relationship is.

If you ask a specific question properly you will likely get a workable
answer. Asking a vague question will not produce much in the way of a
useful
reply.

"Dana" wrote in message
...
This is my question :)

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


Here is the sample Format

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


Dana





"Dana" wrote:

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

Not really clear since you don't say what you want to happen when you re-enter a
number in C39 after clearing it.

Does "add" mean "sum" like you have 10 in G39 and you enter 10 in C39 so G39
becomes 20?

G39 will increase again by the new number in C39?

Also, you would have to use event code to add the value of C39 to the value of
G39 and then clear C39 without changing G39.

Your formula in I39 would only give returns based on what is current in G39


Gord

On Wed, 19 Dec 2007 00:45:01 -0800, Dana wrote:

Dear Stephen / Gord,
Thanks for ur spending times on this post.

Please see this image

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


In that screen,
The values in C39 and D39 is of manual Entries. As soon I
enter the value in C39, that value to be added
to G39 and the value in C39 should be cleared.And the Value in the I39 is
=((G39/10)+(H39/10)*100).

Hope I am clear Now

Thanks in Advanace
Danasegarane




"Gord Dibben" wrote:

I believe that Dana has the rows and columns confused also.

"Second row B2:B15" indicates Column B to this reader.

Perhaps Dana could clarify that the word "row" should be "column"?


Gord Dibben MS Excel MVP


On Tue, 18 Dec 2007 14:22:36 -0000, "Stephen" <none wrote:

Sorry, Dana. I'm not trying to be awkward, but it isn't at all clear from
this how far you have got or what you are having trouble with. Please be
precise about what you are asking. If you have a formula that isn't giving
the result you expect, quote the formula and say what is in the cells to
which it refers. Say what result you get and what you expect. If you don't
know how to write a particular formula, say which cells it will depend on,
what is in them, and (in words) what the relationship is.

If you ask a specific question properly you will likely get a workable
answer. Asking a vague question will not produce much in the way of a useful
reply.

"Dana" wrote in message
...
This is my question :)

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


Here is the sample Format

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


Dana





"Dana" wrote:

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