Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average values in only last 6 columns | Excel Worksheet Functions | |||
Average Last 12 Columns | Excel Discussion (Misc queries) | |||
Average the total of 3 columns | Excel Discussion (Misc queries) | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions |