Average with multiple conditions
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! |
Average with multiple conditions
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! |
Average with multiple conditions
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! |
Average with multiple conditions
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! |
Average with multiple conditions
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! |
All times are GMT +1. The time now is 02:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com