Yet another Average Function with mutl. Columns
 

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.

Yet another Average Function with mutl. Columns
 

Here's my best guess...

This will average Tuesdays when col A is blank.

Array entered** :

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

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

--
Biff
Microsoft Excel MVP


"DaS" wrote in message
...
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.

Yet another Average Function with mutl. Columns
 

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

"T. Valko" wrote:

Here's my best guess...

This will average Tuesdays when col A is blank.

Array entered** :

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

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

--
Biff
Microsoft Excel MVP


"DaS" wrote in message
...
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.

Yet another Average Function with mutl. Columns
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"DaS" wrote in message
...
That worked perfectly! The only thing I was missing on my formula was the
*
symbol. Thanks again!

"T. Valko" wrote:

Here's my best guess...

This will average Tuesdays when col A is blank.

Array entered** :

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

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

--
Biff
Microsoft Excel MVP


"DaS" wrote in message
...
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.