Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Average
I am trying to average out numbers in a column if the number in another
column is a certain number. 1 Y 533 2 N 789 1 Y 465 2 N 222 2 Y 122 2 Y 988 1 N 812 I need a formula that only averages the figures is column C if the number in Column A of the same row is 1. Currently I am using: =IF(C4:C873=1,AVERAGE(M4:M873)) I get a returned value of false. Please any help is useful. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Average
Try this array formula** :
=AVERAGE(IF(C4:C873=1,M4:M873)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) Biff "Fupp83" wrote in message ... I am trying to average out numbers in a column if the number in another column is a certain number. 1 Y 533 2 N 789 1 Y 465 2 N 222 2 Y 122 2 Y 988 1 N 812 I need a formula that only averages the figures is column C if the number in Column A of the same row is 1. Currently I am using: =IF(C4:C873=1,AVERAGE(M4:M873)) I get a returned value of false. Please any help is useful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Average | Excel Worksheet Functions | |||
Conditional Average | Excel Worksheet Functions | |||
Conditional Average | Excel Discussion (Misc queries) | |||
Conditional Average | Excel Worksheet Functions | |||
Conditional Average | Excel Worksheet Functions |