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