doesn't seem to be working. Does it matter that the cells I'm summing are
scattered all over my worksheet?

"Troy" wrote:

If I am summing cells that may or may not contain an error (#n/a) is there a
way to ignore these cells? Or replace (#n/a) with a zero?