How do I calculate averages in column if I'm using a name/string as a place holder that's assigned a value in the NAME area.
I want to assign words to values like, different items are worth different values and instead of having to input the value of each item in a column next to it, i just want to be able to assign that item a value and then at the end of the column calculate the average of each item. I've tried using the NAME in the formula section but I get a div/0 error or a #value error.