Average If Statement

[jimsjams]

Hi there,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I’m trying to add additional criteria to an average if statement and I can’t quite manage it. At the moment I have a statement that works that averages the % sellout of units where the % sellout is greater than 0:
<o> </o>
{=AVERAGE(IF($F$5:$F$1024="% SELLOUT UNITS", IF(H$5:H$1024>0,H$5:H$1024)))}
<o> </o>
What I want to do is add additional criteria, so that as well as the % sellout of units being greater than 0 the type has to be “P” (this is in column G). I think it needs a statement like the following, but I can’t seem to fit the two together.
<o> </o>
IF($G$5:$G$1024="P",H$5:H$1024)
<o> </o>
Hope this makes sense; let me know if you need additional info.
<o> </o>
Thanks in advance for any help / ideas.
<o> </o>
James<o></o>

 

[Aladin Akyurek]

Try...

Control+shift+enter, not just enter:

=AVERAGE(
   IF($F$5:$F$1024="% SELLOUT UNITS",
   IF($G$5:$G$1024="P",    
   IF(H$5:H$1024>0,
     H$5:H$1024))))

Hi there,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I’m trying to add additional criteria to an average if statement and I can’t quite manage it. At the moment I have a statement that works that averages the % sellout of units where the % sellout is greater than 0:
<o> </o>
{=AVERAGE(IF($F$5:$F$1024="% SELLOUT UNITS", IF(H$5:H$1024>0,H$5:H$1024)))}
<o> </o>
What I want to do is add additional criteria, so that as well as the % sellout of units being greater than 0 the type has to be “P” (this is in column G). I think it needs a statement like the following, but I can’t seem to fit the two together.
<o> </o>
IF($G$5:$G$1024="P",H$5:H$1024)
<o> </o>
Hope this makes sense; let me know if you need additional info.
<o> </o>
Thanks in advance for any help / ideas.
<o> </o>
James<o></o>