AMVERAGIF Condition
in [Functions]
|
From: rwtrader on 4 Jun 2010 09:10 I am having trouble adding an AND statement to the condition portion of the AVERAGEIF statement. Is there a trick to doing this?
From: Max on 4 Jun 2010 09:21 Don't know the new function AVERAGEIF, but indicatively something like this array-entered should do it: =average(if((Cond1)*(Cond2),Range)) -- Max Singapore --- "rwtrader" wrote: > I am having trouble adding an AND statement to the condition portion of the > AVERAGEIF statement. Is there a trick to doing this?
From: steve on 4 Jun 2010 09:20 "And" will return true/false, try using IF(AND(-------)) which will return a value as the criteria. Regards Steve "rwtrader" <rwtrader(a)discussions.microsoft.com> wrote in message news:FD0D4875-8F7C-48C4-9AA5-1E3964E0A171(a)microsoft.com... >I am having trouble adding an AND statement to the condition portion of the > AVERAGEIF statement. Is there a trick to doing this?
From: Teethless mama on 4 Jun 2010 09:27 =AVERAGEIF(AvgRange,Range1,Criteria1,Range2,Criteria2) "rwtrader" wrote: > I am having trouble adding an AND statement to the condition portion of the > AVERAGEIF statement. Is there a trick to doing this?
From: Jackpot on 4 Jun 2010 09:32
Try AverageIfs() "rwtrader" wrote: > I am having trouble adding an AND statement to the condition portion of the > AVERAGEIF statement. Is there a trick to doing this? |