Home |
Search |
Today's Posts |
#1
|
|||
|
|||
assign a value to text
I have read a lot of posts, and maybe I am way out of my leage.
I am trying to setup a spreed sheet for our fire department. We want to create a way to track training pay. When someone attends the training we want to just put an "x" in next to their name in the column for that training event rather then 9.75 for example. But we also want to be able to add up all training for that individual for the year and see what we paid them. The idea is we have a sheet that shows us checks of who attended and who did not. But we also want to add up the pay associated with that x. So: We want column A to be member names Column B is a training event. We want to go down and put in an "X" for each member who attended. Now What I want is to have that "x" be associated with a dollar value. For example lets say that they get $10 for that training. THe idea is that I can run a total at the end of the year for each member for each "x" and see how much money they recieved. I.E. the "x" is a hidden value maybe that when I add up all the "x"s for a member it will give me total dolar value for all training they attended. I hope that makes sensce and I don't know a lot about excel. THanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I assign a numeric value to a text letter | Excel Discussion (Misc queries) | |||
How to assign character (text) values to y-axis in a Excel chart? | Charts and Charting in Excel | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
How do I assign a text value to a variable number of rows? | Excel Worksheet Functions | |||
Assign numerical values to text codes | Excel Worksheet Functions |