Excel Question

Can anyone help me find a way to handle a #VALUE error. I’m adding fields from a worksheet and placing them on a new worksheet. It’s tracking by month, and when the fields are blank (prior to entering the data) the total sheet shows #VALUE. How can I get it to show blanks rather than the error