Count Down

[Brown]

Hello,
It has been a while since I have asked any questions, but I am sure you folks will steer me in the right direction.
Thanks in advance

I am trying to create a gradebook, of sorts, in which each time I enter a number it will subtract from 100
Sorry I couldn't get the image to work

http://i287.photobucket.com/albums/ll127/nu2trout/excel image_zpsqia7tvc9.png


for example, in cell a2 I will place the value 100
when I enter a mark in cell b2 (like an X) I need it to lower the value from 100 by 1 (so now a2 shows 99)

I hope that makes sense, and I look forward to reading your thoughts and suggestions
Brown

 

[Joe4]

Let's say that you wanted to subtract the total number of "X"s that appear in column B, then you would put this formula in A2:

=100-COUNTIF(B:B,"X")

Note that if you want to "hard-code" 100 in cell A2, and have that value automatically updated when values elsewhere are updated, that will require VBA.
If you would like to pursue that option, please let us know that total range affecting it.
Is it just B2, or all of column B or row 2 (other than column A)?

 

[Brown]

Thank for the quick response, i will try it now

It is all of row 2, so the "grade" will stay in A2 (100-x's), and the row will have the X's placed in the boxes denoting the subtraction of one point per X, so one row is for one student. I will have multiple rows

 

[Joe4]

If it is all or row 2, then it would be something like this:

=100-COUNTIF(B2:CW2,"X")

Just update the range to reflect the range you are checking for X's.

 

[Brown]

GOT IT THANKS!!!!!!!
I used what you sent and placed the range for the row.
Have a great day
Brown

 

[Joe4]

You are welcome.