0

I am trying to find average of a column based on the values from other column with different array formulas :

Using boolean +

=AVERAGE(IF(($F$2:$F$390="A")+($F$2:$F$390="B"),$D$2:$D$390))

Result is 40 and it is correct

Using Curly brackets inside IF

=AVERAGE(IF($F$2:$F$390 = {"A","B"},$D$2:$D$390))

Result is 40 and it is correct

Using OR Operator

=AVERAGE(IF(OR($F$2:$F$390 = "A",$F$2:$F$390 = "B"),$D$2:$D$390))

Result is 37 and it is wrong.

Could anyone help me to find, what mistake in the 3rd method using OR operator is giving wrong result ??

(PS : All are array formulas executed using Ctrl + Shift + Enter )

Tim Williams
  • 122,926
  • 8
  • 79
  • 101
Rahul
  • 41
  • 5

0 Answers0