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