Hi,
I'm looking for some help with a formula for a spreadsheet i'm producing. I'm limited in skill and got to a point where I need a spreadsheet to auto-accumalate. I'm unsure how to give text a numerical value, and then based on the text- a total to be accumulate per column as a numerical value.
Any help would be appreciated and if it helps I can forward a copy of the document i'm trying to produce.
Cheers
Neil