I need to get a sum function to recognise an 'x' or 'NA' as a number as not
to mess up an overall percentage function later on in the worksheet.
This is for an inspection & cells would usually have a 1 - 5 value placed in
them but sometimes the field is not applicable.
Is it possible??
Can anyone help??