This is my second day on this issue. I need to average a row but do not want to include any rows with "0". I have tried =AVERAGEIF(range,">0",range) and this does not work with 2003. Also, how do you get cells to 'not' calculate if another data cell is missing information? (i.e. my spreadsheet contains times and I am looking for the difference between these times....I have the correct formulas for this, but want to add something to the formula that will show my time difference AND will not show "0" for those rows that data has not yet been entered.
Bookmarks