Hi! This is probably a common problem but I don't know the answer.
I have a list of values, each based upon a lookup to another worksheet. Some of the values returned are good, others are N/A when no value is found. In order to sum this list, I typically past value these cells and replace "N/A" with "0", thus enabling the sum function.
Is there a way to sum this list while keeping the lookup formulae, thereby avoiding the copy value & replace method I currently use?
I have a list of values, each based upon a lookup to another worksheet. Some of the values returned are good, others are N/A when no value is found. In order to sum this list, I typically past value these cells and replace "N/A" with "0", thus enabling the sum function.
Is there a way to sum this list while keeping the lookup formulae, thereby avoiding the copy value & replace method I currently use?