Yet another Average Function with mutl. Columns

  • Thread starter Thread starter DaS
  • Start date Start date
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.
 
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)
 
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
need help writing function 9
Averaging excluding blanks--Multiple Tabs 2
Countif Function?? 3
Average of Day and Time 3
Finding the right function & formula 4
Count Week Of Month 4
Calculate End Date Using Start Date and No. of Days excluding specific days. 0

Back
Top