how to sum cells and ignore the #div/0! 's ?
"Todd" wrote:
I have a column of data that links to another sheet I need a ytd total for.
The problem is that the cells contain formulas (on the feeding sheet) that
return #div/0! until the date has passed and data is entered into its
referring cells.
Is there a way I can sum these columns and ignore the #div/0! 's ? I had
been using a simple a20+a40+a60 type formula.
Thanks,
Todd
|