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. |
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. |
All times are GMT +1. The time now is 10:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com