In Column A, there are specific events that occured. In B there is each day
of the week for each month, Monday-Sunday. I am trying to average each day
of the week, from a total in Column E only if Column A is blank--Confused yet?


A B C
E
New Years Monday 01/01/2007
215
Tuesday 01/02/2007
82
Wednesday..etc 01/03/2007
75
MLK Monday 01/15/2007
118


The formula would omit both above Mondays because Column A isn't blank, and
include the remaining Mondays in the average, however it would avereage all
of the given Tuesdays throughout the month, because they are blank.