Yet another Average Function with mutl. Columns

[DaS]

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.

 

[T. Valko]

Here's my best guess...

This will average Tuesdays when col A is blank.

Array entered** :

=AVERAGE(IF((A1:A4="")*(B1:B4="Tuesday"),D14))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

 

[DaS]

That worked perfectly! The only thing I was missing on my formula was the *
symbol. Thanks again!

 

[T. Valko]

You're welcome. Thanks for the feedback!