Prev: Head scratchin for hours.... Help with a formula please...
Next: The IFERROR() Function in Excel 2007
From: abdul gaffoor abdul on 24 Apr 2010 19:31
> 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.