I've got a spreadsheet that shows the averages of riders per revenue hour. First, I don't like averaging a row of averages, but you gotta do what you gotta do. But there are some routes that we've eliminated or changed and so won't have any more entries. Because of history, I've got to leave them on the sheet. When I average the column, it counts the blanks or zeros. Apparently, I'm doing something wrong, because I can't get the averageif to work here. Can you help? For example, row 44 should be the average of rows 6-42. But of course, without the blank cells. Thanks Excel 2007
Scarames
Bookmarks