If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|