Excel 2007 : Help with AVERAGEIFS formula including conditions

[milliemoo]

Hello,

I am trying to work out how to write a formula that calculates the average value in column X if the following conditions apply:

Column F = "Yes"
Neither column R nor V are blank
The value in column V falls in date range 23/04/2012 - 18/05/2012
Column C does not equal "JPN"

Any help would be very much appreciated.

Thank you

[GeneralDisarray]

=SUMPRODUCT((X:X)*(F:F="Yes")*(R:R<>"")*(V:V<>"")*(C:C<>"JPN"))/SUMPRODUCT((X:X<>"")*(F:F="Yes")*(R:R<>"")*(V:V<>"")*(C:C<>"JPN"))





check out this post:

http://www.excelhero.com/blog/2010/0...umproduct.html

[NBVC]

Try:

=AVERAGEIFS(X:X,F:F,"Yes",R:R,"<>",V:V,">="&DATE(2012,4,23),V:V,"<="&DATE(2012,5,18),C:C,"<>JPN")