I am in need of some experts to guide me in my spreadsheet. I am trying to
put an accountibility sheet together and I would like to do this. I have a
subject in A1 cell. that is constant. And I have given B1 a constant value.
Now In cells C1-H1 I will be inserting a daily count. What I would like to do
is put in the count yet I would like for It to total in the cell automaticly.
Example. B1=3 and I insert a 5 in C1 and I would like to have it say 15 and
in D1 I insert a 3 and I would like for it to say 9. Now At the end of the
range of A1-H1 it doesn't have a total. I do not intend to have a total. I am
using excel 2003.I was told to use =A1*3. I would think that that would work
if each cell after B1 is 3 is isn't however. I hope this makes sense.Also, I
know that I also need the steps to insert the formula.

You need more columns!

You cannot do what you want in one cell. You cannot have a single cell equal
both the value you just typed into it and that value altered in some way,
such as by being multiplied by contents of B1.

Lets tackle just one or two of them and I think you'll see what you need to
do:

A B C D ..... H I J
1 xxx 3 5 3 =B1 * C1 =B1 * D1
2

Your constant 3 is in B1, you type 5 into c and I will show 15, you type 3
in D and J1 would show 9.

To put the formulas into a cell, just select that cell and type just like
I've shown above, beginning with the = symbol. So in I1, you would use the
following keyboard sequence:
=B1*C1[Enter]

After typing a formula like that you don't have to type it again on each and
every row. You can "fill" or "extend" the formula down the sheet and the row
numbers will change automatically. Use Excel Help and search for
Fill data in worksheet cells
and look for a topic returned from the search with that title and read it
for assistance on filling with the formula down the sheet.

"Ciscokid" wrote:

I am in need of some experts to guide me in my spreadsheet. I am trying to
put an accountibility sheet together and I would like to do this. I have a
subject in A1 cell. that is constant. And I have given B1 a constant value.
Now In cells C1-H1 I will be inserting a daily count. What I would like to do
is put in the count yet I would like for It to total in the cell automaticly.
Example. B1=3 and I insert a 5 in C1 and I would like to have it say 15 and
in D1 I insert a 3 and I would like for it to say 9. Now At the end of the
range of A1-H1 it doesn't have a total. I do not intend to have a total. I am
using excel 2003.I was told to use =A1*3. I would think that that would work
if each cell after B1 is 3 is isn't however. I hope this makes sense.Also, I
know that I also need the steps to insert the formula.

I would like to thank you for your help. I was able setup and I also learned
a lot of new stuff to help me do a better job. I truly wish to thank you!:)

"JLatham" wrote:

You need more columns!

You cannot do what you want in one cell. You cannot have a single cell equal
both the value you just typed into it and that value altered in some way,
such as by being multiplied by contents of B1.

Lets tackle just one or two of them and I think you'll see what you need to
do:

A B C D ..... H I J
1 xxx 3 5 3 =B1 * C1 =B1 * D1
2

Your constant 3 is in B1, you type 5 into c and I will show 15, you type 3
in D and J1 would show 9.

To put the formulas into a cell, just select that cell and type just like
I've shown above, beginning with the = symbol. So in I1, you would use the
following keyboard sequence:
=B1*C1[Enter]

After typing a formula like that you don't have to type it again on each and
every row. You can "fill" or "extend" the formula down the sheet and the row
numbers will change automatically. Use Excel Help and search for
Fill data in worksheet cells
and look for a topic returned from the search with that title and read it
for assistance on filling with the formula down the sheet.

"Ciscokid" wrote:

I am in need of some experts to guide me in my spreadsheet. I am trying to
put an accountibility sheet together and I would like to do this. I have a
subject in A1 cell. that is constant. And I have given B1 a constant value.
Now In cells C1-H1 I will be inserting a daily count. What I would like to do
is put in the count yet I would like for It to total in the cell automaticly.
Example. B1=3 and I insert a 5 in C1 and I would like to have it say 15 and
in D1 I insert a 3 and I would like for it to say 9. Now At the end of the
range of A1-H1 it doesn't have a total. I do not intend to have a total. I am
using excel 2003.I was told to use =A1*3. I would think that that would work
if each cell after B1 is 3 is isn't however. I hope this makes sense.Also, I
know that I also need the steps to insert the formula.

You're most certainly very welcome. Thanks for the feedback.

"Ciscokid" wrote:

I would like to thank you for your help. I was able setup and I also learned
a lot of new stuff to help me do a better job. I truly wish to thank you!:)

"JLatham" wrote:

You need more columns!

You cannot do what you want in one cell. You cannot have a single cell equal
both the value you just typed into it and that value altered in some way,
such as by being multiplied by contents of B1.

Lets tackle just one or two of them and I think you'll see what you need to
do:

A B C D ..... H I J
1 xxx 3 5 3 =B1 * C1 =B1 * D1
2

Your constant 3 is in B1, you type 5 into c and I will show 15, you type 3
in D and J1 would show 9.

To put the formulas into a cell, just select that cell and type just like
I've shown above, beginning with the = symbol. So in I1, you would use the
following keyboard sequence:
=B1*C1[Enter]

After typing a formula like that you don't have to type it again on each and
every row. You can "fill" or "extend" the formula down the sheet and the row
numbers will change automatically. Use Excel Help and search for
Fill data in worksheet cells
and look for a topic returned from the search with that title and read it
for assistance on filling with the formula down the sheet.

"Ciscokid" wrote:

I am in need of some experts to guide me in my spreadsheet. I am trying to
put an accountibility sheet together and I would like to do this. I have a
subject in A1 cell. that is constant. And I have given B1 a constant value.
Now In cells C1-H1 I will be inserting a daily count. What I would like to do
is put in the count yet I would like for It to total in the cell automaticly.
Example. B1=3 and I insert a 5 in C1 and I would like to have it say 15 and
in D1 I insert a 3 and I would like for it to say 9. Now At the end of the
range of A1-H1 it doesn't have a total. I do not intend to have a total. I am
using excel 2003.I was told to use =A1*3. I would think that that would work
if each cell after B1 is 3 is isn't however. I hope this makes sense.Also, I
know that I also need the steps to insert the formula.