Average with multiple conditions

[Dez]

Hi how do i take the avearage of numbers in one column, with conditions being
satisfied in two other different colums?

this is what i've tried but it's just not working;

AVERAGE(IF(AND($B$2:$B$1931="2000"),$C$2:$C$1931="1",$D$2:$D$1931))

could someone please help. thanks!

 

[T. Valko]

Try this array formula**:

=AVERAGE(IF((B2:B1931=2000)*(C2:C1931=1),D21931))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

 

[Dez]

that worked. thanks heaps!!

Try this array formula**:

=AVERAGE(IF((B2:B1931=2000)*(C2:C1931=1),D21931))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

 

[Wigi]

The DAVERAGE function might also be useful, though that depends on the data
layout.

 

[T. Valko]

You're welcome. Thanks for the feedback!