I am trying to make a grading sheet. I want each cell in column to be a
specific value. So if I type in an X it is really a value of say something
like 3 or 4. Then I want the each row to tally a total in a seperate cell.

For example the first row is A1, B1, C2, D3 and E4.
A1 = 5 when I put an X in it.
B1 = 4 when I put an X in it.
C1 = 3 when I put an X in it.
D1 = 2 when I put an X in it.
E4 is the sum of the row.

I don't want to have to type in the value of each cell each time, I just
want to put an X in it.

OOps, I meant For example the first row is A1, B1, C1, D1 and E1.


"polygrinder" wrote:

I am trying to make a grading sheet. I want each cell in column to be a
specific value. So if I type in an X it is really a value of say something
like 3 or 4. Then I want the each row to tally a total in a seperate cell.

For example the first row is A1, B1, C2, D3 and E4.
A1 = 5 when I put an X in it.
B1 = 4 when I put an X in it.
C1 = 3 when I put an X in it.
D1 = 2 when I put an X in it.
E4 is the sum of the row.

I don't want to have to type in the value of each cell each time, I just
want to put an X in it.

In Cell A2, use the formula =IF(A1="X", 5, 0). This would give A2 a
value of 5 if there is an X in A1, and a value of 0 if there is no X.
You can do the same across the next few columns, changing letter values
and number values as appropriate. You would then to a simple SUM in E1
to add up all of the values of the row to get your total. There may be
a more elegant solution to this problem, but this is the first one I
thought of and I am not an Excel guru.



polygrinder wrote:
OOps, I meant For example the first row is A1, B1, C1, D1 and E1.


"polygrinder" wrote:

I am trying to make a grading sheet. I want each cell in column to be a
specific value. So if I type in an X it is really a value of say something
like 3 or 4. Then I want the each row to tally a total in a seperate cell.

For example the first row is A1, B1, C2, D3 and E4.
A1 = 5 when I put an X in it.
B1 = 4 when I put an X in it.
C1 = 3 when I put an X in it.
D1 = 2 when I put an X in it.
E4 is the sum of the row.

I don't want to have to type in the value of each cell each time, I just
want to put an X in it.

Matthew,

Thanks for the help. OK, I followed what you said and set it up. It
automatically put a "0" in all of the cells. Now if I put an X in the cell it
deletes the formula. How do I get the formula to stay when I put in an X in
the cell?

"Matthew Cavagnaro" wrote:

In Cell A2, use the formula =IF(A1="X", 5, 0). This would give A2 a
value of 5 if there is an X in A1, and a value of 0 if there is no X.
You can do the same across the next few columns, changing letter values
and number values as appropriate. You would then to a simple SUM in E1
to add up all of the values of the row to get your total. There may be
a more elegant solution to this problem, but this is the first one I
thought of and I am not an Excel guru.



polygrinder wrote:
OOps, I meant For example the first row is A1, B1, C1, D1 and E1.


"polygrinder" wrote:

I am trying to make a grading sheet. I want each cell in column to be a
specific value. So if I type in an X it is really a value of say something
like 3 or 4. Then I want the each row to tally a total in a seperate cell.

For example the first row is A1, B1, C2, D3 and E4.
A1 = 5 when I put an X in it.
B1 = 4 when I put an X in it.
C1 = 3 when I put an X in it.
D1 = 2 when I put an X in it.
E4 is the sum of the row.

I don't want to have to type in the value of each cell each time, I just
want to put an X in it.

Matthew,

OK, I got it. I missed that I was putting the formula below in A2.

"Matthew Cavagnaro" wrote:

In Cell A2, use the formula =IF(A1="X", 5, 0). This would give A2 a
value of 5 if there is an X in A1, and a value of 0 if there is no X.
You can do the same across the next few columns, changing letter values
and number values as appropriate. You would then to a simple SUM in E1
to add up all of the values of the row to get your total. There may be
a more elegant solution to this problem, but this is the first one I
thought of and I am not an Excel guru.



polygrinder wrote:
OOps, I meant For example the first row is A1, B1, C1, D1 and E1.


"polygrinder" wrote:

I am trying to make a grading sheet. I want each cell in column to be a
specific value. So if I type in an X it is really a value of say something
like 3 or 4. Then I want the each row to tally a total in a seperate cell.

For example the first row is A1, B1, C2, D3 and E4.
A1 = 5 when I put an X in it.
B1 = 4 when I put an X in it.
C1 = 3 when I put an X in it.
D1 = 2 when I put an X in it.
E4 is the sum of the row.

I don't want to have to type in the value of each cell each time, I just
want to put an X in it.