Simple but I cannot....

  • Thread starter Thread starter TK
  • Start date Start date
T

TK

Can I make it any simplier. I want to make a tracking form.
The first col. A is customer name and address,Col. B is
date of purchase, Col. C is method of payment, Col. D is
item, Col. E is Amount and Col. F is total....total is the
Amount added to the last amount in the Total, so the total
goes up with each Amount entry.

Well, I cannot get this to work. In Col F, I type a
formula =Total+Amount. Nothing happens, except sometimes
when I type this in the space, the heading on the column
comes out #Name.

This thing is driving me crazy.

Are there instructions that can help me with a most basic
fuction as this ?

TK
 
one way:

Assuming the column titles are in row 1, in F2 enter

=E2

then in F3 enter

=F2+E3

and copy down
 
So I need to put that in every F column ? There is must be
a way to just tell the program to do that in every row in
column F.
 
TK said:
So I need to put that in every F column ? There is must be
a way to just tell the program to do that in every row in
column F.
Click to expand...

there is - you need to put the formula in each cell in column F. That IS "a
way to just tell the program to do that in every row "!
 
If all your sheets are set up the same, hold your shift key down and select all
sheets, enter the formulas as JE told you to, then right click on one of the
tabs and select Ungroup.




: So I need to put that in every F column ? There is must be
: a way to just tell the program to do that in every row in
: column F.
: >-----Original Message-----
: >one way:
: >
: >Assuming the column titles are in row 1, in F2 enter
: >
: > =E2
: >
: >then in F3 enter
: >
: > =F2+E3
: >
: >and copy down
: >
: >
: >In article <[email protected]>,
: >
: >> Can I make it any simplier. I want to make a tracking
: form.
: >> The first col. A is customer name and address,Col. B is
: >> date of purchase, Col. C is method of payment, Col. D
: is
: >> item, Col. E is Amount and Col. F is total....total is
: the
: >> Amount added to the last amount in the Total, so the
: total
: >> goes up with each Amount entry.
: >>
: >> Well, I cannot get this to work. In Col F, I type a
: >> formula =Total+Amount. Nothing happens, except
: sometimes
: >> when I type this in the space, the heading on the
: column
: >> comes out #Name.
: >>
: >> This thing is driving me crazy.
: >>
: >> Are there instructions that can help me with a most
: basic
: >> fuction as this ?
: >>
: >> TK
: >.
: >
 
If you're using MacXL, or WinXL03, use the List Manager (it's not called
List Manager in XL03 - look up "Create a List" in XL Help), and set
column F to be a calculated column. Whenever you add a value in the
input row, the formula will be entered in column F.
 
When you put the formula in F3 move the mouse to the lower right corner of
that cell so that a + appears instead of the normal arrow cursor. Then
double click the left mouse button. This will copy the formula down provided
there are entries in column E.
 
Why is this soo difficult, everyone seems to have a
different way to do this and I can not make sense of any
of them.

I can find no way to create a list, or do those other
things suggested.

Is there not a simple way to have a column be the sum of
itself (F) and another column (E)each time E is added to ?

I am sure all the suggestions are good, but I do not know
this program or the jargon that goes with it. I just want
to be able to set up something really simple.

I am using Excel 2000.

Thanks,

TK
 
There are a number of ways to solve a problem in Excel and each solutio
in itself is valid. What is simple to you may not be simple to th
others and vice-versa. Just pick a solution that you are comfortabl
with and use it.

It is only difficult if you insist it is difficult ...
 
TK said:
Why is this soo difficult, everyone seems to have a
different way to do this and I can not make sense of any
of them.

I can find no way to create a list, or do those other
things suggested.

Is there not a simple way to have a column be the sum of
itself (F) and another column (E)each time E is added to ?

I am sure all the suggestions are good, but I do not know
this program or the jargon that goes with it. I just want
to be able to set up something really simple.

I am using Excel 2000.

Thanks,
Click to expand...

A spreadsheet is just an electronic version of the old analysis paper -
(remember that?) in other words, it will not do anything unless you tell it
to! if you want a cell to be a calculated cell, you HAVE to put a formula of
some sort into it, there is NO other way of getting data automatically into
that cell. What you CAN do, is to enter the formula into the first cell in
the column, and then copy it down as far as you think your list will extend.
If you want to be really clever, you can use an "IF" statement so that until
a value is put into the corresponding cell in "E" , the summed cell is
blank.
 
Gordon said:
A spreadsheet is just an electronic version of the old analysis paper
- (remember that?) in other words, it will not do anything unless you
tell it to! if you want a cell to be a calculated cell, you HAVE to
put a formula of some sort into it, there is NO other way of getting
data automatically into that cell. What you CAN do, is to enter the
formula into the first cell in the column, and then copy it down as
far as you think your list will extend. If you want to be really
clever, you can use an "IF" statement so that until a value is put
into the corresponding cell in "E" , the summed cell is blank.
Click to expand...

In addition, you might be well advised to go out and buy a copy of "Excel
for Dummies" and do some reading up on what Excel is and how you can do
things with it.
 
TK

You would best off to go purchase a book on Excel You did not in your earlier
postings ask about creating a list, you were asking about making a formula
work --- you got many suggestions

Is there anyone where you work who can help you???

:
: Why is this soo difficult, everyone seems to have a
: different way to do this and I can not make sense of any
: of them.
:
: I can find no way to create a list, or do those other
: things suggested.
:
: Is there not a simple way to have a column be the sum of
: itself (F) and another column (E)each time E is added to ?
:
: I am sure all the suggestions are good, but I do not know
: this program or the jargon that goes with it. I just want
: to be able to set up something really simple.
:
: I am using Excel 2000.
:
: Thanks,
:
: TK
:
:
: >-----Original Message-----
: >Can I make it any simplier. I want to make a tracking
: form.
: >The first col. A is customer name and address,Col. B is
: >date of purchase, Col. C is method of payment, Col. D is
: >item, Col. E is Amount and Col. F is total....total is
: the
: >Amount added to the last amount in the Total, so the
: total
: >goes up with each Amount entry.
: >
: >Well, I cannot get this to work. In Col F, I type a
: >formula =Total+Amount. Nothing happens, except sometimes
: >when I type this in the space, the heading on the column
: >comes out #Name.
: >
: >This thing is driving me crazy.
: >
: >Are there instructions that can help me with a most basic
: >fuction as this ?
: >
: >TK
: >.
: >
 
Back
Top