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!