I have a workbook that calculates a sum of numbers for each week requested (a reporting tool) from 7-8 worksheets within this workbook.
My problem is that sometimes a cell does not contain a number so it is blank and when the formula looks at it to add the value to the sum, it is reading it as a different data type and can't add the "0" value to the ongoing sum calculation.
I hope that makes sense...we keep getting a debug error because it can't sum up all the numbers.
My problem is that sometimes a cell does not contain a number so it is blank and when the formula looks at it to add the value to the sum, it is reading it as a different data type and can't add the "0" value to the ongoing sum calculation.
I hope that makes sense...we keep getting a debug error because it can't sum up all the numbers.