If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
AMVERAGIF Condition
I am having trouble adding an AND statement to the condition portion of the
AVERAGEIF statement. Is there a trick to doing this? |
#2
|
|||
|
|||
AMVERAGIF Condition
"And" will return true/false, try using IF(AND(-------)) which will return a
value as the criteria. Regards Steve "rwtrader" wrote in message ... I am having trouble adding an AND statement to the condition portion of the AVERAGEIF statement. Is there a trick to doing this? |
#3
|
|||
|
|||
AMVERAGIF Condition
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? |
#4
|
|||
|
|||
AMVERAGIF Condition
=AVERAGEIF(AvgRange,Range1,Criteria1,Range2,Criter ia2)
"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? |
#5
|
|||
|
|||
AMVERAGIF Condition
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? |
#6
|
|||
|
|||
AMVERAGIF Condition
There is no need to use AND
This formula =AVERAGEIFS(A2:A10,B2:B10,"=20",B2:B10,"=50") will average the values in the A range when the corresponding B values lie in the interval 20 to 50 best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme REMINDER: These newsgroups are about to die. We will all meet again at http://social.answers.microsoft.com/...ry/officeexcel "rwtrader" wrote in message ... I am having trouble adding an AND statement to the condition portion of the AVERAGEIF statement. Is there a trick to doing this? |
#7
|
|||
|
|||
AVERAGEIF Condition
What is the syntax for AverageIfs? I don't see that function in 2007.
"Jackpot" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|