Hi,

I need to set up a formula where I need to extract data from a specified range of cells, however, if the cell doesn't contain any values (its blank), a "0" will be placed instead. Can I first of all create a forumula for this, and if so, how.

Thanks in advance for anyone's assistance.

Calli,