--Type 0 in a blank cell which is out of your data area. Say (cell T1)
--Copy the cell.
--Keeping the copy select your data area including cells which have figures
and are blank
--Right clickPasteSpecialcheck 'Add'OK

If this post helps click Yes
---------------
Jacob Skaria


"Tim" wrote:

I am uploading values from an existing data base. Sometimes there is no items
sold during the time so it just gives me a blank area. I need to change that
to a zero so it will calculate correctly. I have tried @if statements but am
getting no results sinve the area is blank to begin with. All i need is a
statement that says if the area is blank result =0, or the number that is
there.

Thanks for any help.