Troy,

'doesn't seem to be working' isn't a very useful description of the problem,
post the formula you tried.

Mike

"Troy" wrote:

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?