Yet another Average Function with mutl. Columns

D

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

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"),D1:D4))

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

DaS

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average Function 6
Unhide column difficulty 3
Countif Function?? 3
AverageIf function with multiple columns 1
Adding Days 2
Average of Day and Time 3
need help writing function 9
AVERAGE last 4 Mondays? 1

Top