Adding Values to Cells

[Dana]

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

 

[Roger Govier]

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)

 

[Dana]

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

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

Thanks
Dana

 

[Roger Govier]

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

 

[Dana]

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

 

[David Biddulph]

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

Dear Roger,
The column in E is ((C39+D39)/100)*100.

....

 

[Dana]

Sorry for that .There is nothing in that .

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


....

 

[Dana]

Any one have some idea ?

Sorry for that .There is nothing in that .

 

[Stephen]

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

 

[Dana]

Any idea for my question in the first Post

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

 

[Stephen]

Which question in your first post? Like many people here, I'm seeing your
posts through a newsreader, not via a web interface. I can read whatever I
can scroll down to below, but not (without additional work) what is in
previous posts and not quoted below. If you would care to copy the text of
your original question and paste into a further reply, or reply to the
original post rather than David Biddulph's reply where the original question
has been snipped, I (and more importantly others) will know what the
original question was. Whether I can usefully respond is, of course, another
matter! But others may well be able to do so.

 

[Dana]

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

 

[Stephen]

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.

 

[Gord Dibben]

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

 

[Dana]

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

 

[Stephen]

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]

[Quoate]
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.)

[\Quoate]

Yes Stephen,
I need a macro. And for the second point , it will be good I
wll request my friend to think for it

Thanks
Dana

 

[Gord Dibben]

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

 

[Dana]

Thanks for the reply Gord.

[Quoate]
Not really clear since you don't say what you want to happen when you
re-enter a
number in C39 after clearing it.
[/Quoate]
The values which I am entering are to be summed to the G39 and then the
value in the C39 to be cleared

[Quoate]
Does "add" mean "sum" like you have 10 in G39 and you enter 10 in C39 so G39
becomes 20?
[/Quoate]
Yes Here "add" means "sum " only.
[Quoate]
G39 will increase again by the new number in C39?
[/Quoate]
Yes. Whatever the value I enter in C39 to be summed to G39

Dana