Ok, here is my delima. I am creating a spreadsheet that calculates student grades and averages. Each week I have an average that i calculate for the week (which works fine) then i want to average each week into a final column for final grade. Even if i don't enter a grade for a specific day i used the sumif/countif to calculate that average, which works because all the grades run in a specific even range (ie - A6:G6) The problem comes in when i am trying to average all of the weeks to get a final grade which is continuously being averaged. Since the sumif only accepts a range i can't get it to calculate. For example- the weekly averaged cells are A6, M6, K6, etc. Where the problem lies is that the final grade column is using calcualted fields to get it's final average. Some of which have not yet been calculated. In other cases i just used sumif to not include fields that are = #DIV/0!. This won't work since the numbers being evaluated aren't in a range. Please let me know what i can do to get around this. Thanks in advance for your help. I am using excel 2000.

Try here, MrExcel Forums http://216.92.17.166/board2/ It's not that I can't remember things as I get older, it's just that my hard drive's full.

I want to create a spreadsheet in Excel 2000 in which I enter my start time, lunch out and lunch in times and show the total hours as 8. I then want to enter a formula in the end time column to show the time I should punch out in order to not go over 8 hours. Any help? Flo