LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default How do I make an X be a specific value

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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Eliminating Duplicate GROUPS of Styles Greg Purnell Excel Worksheet Functions 6 October 2nd 06 04:24 AM
Can I make a graph to be a specific size? (actual graph) Jessica Excel Discussion (Misc queries) 0 August 14th 06 08:45 PM
How can I make a specific cell blinking GY Fong - HK Excel Worksheet Functions 1 July 27th 06 09:36 AM
find specific text and make cell highlighted after the future Excel Discussion (Misc queries) 2 May 26th 06 02:11 PM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 01:01 PM


All times are GMT +1. The time now is 07:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"