What does this array formula say?

[GN0001]

{=AVERAGE(IF(Haystack!$C$2:$C$8=A2,IF(Haystack!$D$2:$D$8=B2,Haystack!$B$2:$B$8)))}

if statement says; if(condition, True, False)

Condition:

If condition is true, do this

If condition is false, do something else (based on the condition)

___________________________________________________________________

recently I see some if statements that the false part of that is omitted, what does this function on the top says?

Regards,

Guity

 

[Hui]

Average the values in Haystack B2:B8 where Haystack C2:C8=A2 and D2:D8=B2

 

[GN0001]

Hui,

Thanks a lot.

Guity

 

[Hui]

Guity

If your using excel 2007/10 you could use the normal formula

=AVERAGEIFS(Haystack!$B$2:$B$8,Haystack!$C$2:$C$8,A2,Haystack!$D$2:$D$8,B2)