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!

Try this array formula**:

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

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

--
Biff
Microsoft Excel MVP


"Dez" wrote in message
...
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!

that worked. thanks heaps!!

"T. Valko" wrote:

Try this array formula**:

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

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

--
Biff
Microsoft Excel MVP


"Dez" wrote in message
...
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!

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

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Dez" wrote:

that worked. thanks heaps!!

"T. Valko" wrote:

Try this array formula**:

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

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

--
Biff
Microsoft Excel MVP


"Dez" wrote in message
...
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!

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Dez" wrote in message
...
that worked. thanks heaps!!

"T. Valko" wrote:

Try this array formula**:

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

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

--
Biff
Microsoft Excel MVP


"Dez" wrote in message
...
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!