I'd advice to redesign your source table(s)! So that in every column are only either entered data, or formulas (in every column will be only one kind of information). This will help you to avoid not only the current problem, but also a lot of future ones.