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!