Formula to get AVERAGE

[RSEKAR]

Dear Sir,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
In both G and O column contain numerical data. Range (G10:G950) and (O10:O950)<o></o>
Both columns contain 0 Values also. O column contains both > 0 and < 0 values.<o></o>
The formula should display the Average value for the data > 0 in (O10:O950) for the data > 0 in (G10:G950)<o></o>
I use Excel 2002 version and OS XP.

 

[Weaver]

One possibility

=sumif(O10:O950,">0")/countif(O10:O950,">0")

 

[Aladin Akyurek]

Dear Sir,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
In both G and O column contain numerical data. Range (G10:G950) and (O10:O950)<o></o>
Both columns contain 0 Values also. O column contains both > 0 and < 0 values.<o></o>
The formula should display the Average value for the data > 0 in (O10:O950) for the data > 0 in (G10:G950)<o></o>
I use Excel 2002 version and OS XP.

Try...

Control+shift+enter, not just enter:

=AVERAGE(
     IF(ISNUMBER(G10:G950),
     IF(G10:G950>0,
     IF(ISNUMBER(O10:O950),
     IF(O10:O950>0,O10:O950)))))

 

[RSEKAR]

What about the other condition the data should be > 0 in (G10:G950)

 

[RSEKAR]

Dear Mr.Aladin Akyurek<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Your array formula is working well displaying correct AVERAGE Values.<o></o>
Thank you very much.<o></o>

 

[Aladin Akyurek]

Dear Mr.Aladin Akyurek<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Your array formula is working well displaying correct AVERAGE Values.<o></o>
Thank you very much.<o></o>

Great. Thanks for providing feedback.

 

[T. Valko]

Dear Sir,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
In both G and O column contain numerical data. Range (G10:G950) and (O10:O950)<o></o>
Both columns contain 0 Values also. O column contains both > 0 and < 0 values.<o></o>
The formula should display the Average value for the data > 0 in (O10:O950) for the data > 0 in (G10:G950)<o></o>
I use Excel 2002 version and OS XP.

If you're using Excel 2007 or later...

=AVERAGEIFS(O10:O950,G10:G950,">0",O10:O950,">0")