Quote Originally Posted by axc0054
I am doing the same, though in one sheet the value does not exist. Is there a way for it to display a zero? ISERROR? IF?
axc0054,


Please do not "hijack" threads.... you should start your own thread and if need be reference another thread with a link to it.

I did notice this is not the first thread you "hijacked" today.