Perhaps you could use:

=SUMIFS( ... ) / COUNTIFS( ... )

with the same conditional parameters in the two functions.

(Sorry, I don't have XL2007, so am unsure of the syntax).

Hope this helps.

Pete

On Nov 28, 11:37*am, JRD wrote:
Example:
* * * * *A * * * * * * * * * * * * B * * * * * * * * * * * * * * * *C * * * * * * * * * * *D * *
1 * * 01/10/2009 * * * * Cancelled * * * * * * * *John, Steven * * * * * * 4
2 * * 01/09/2009 * * * * Reported * * * * * * * * John, Steven * * * * * * 2
3 * * 20/10/2009 * * * * Reported * * * * * * * *John, Darren * * * * * * N/A
4 * * 12/10/2009 * * * * *Reported * * * * * John, Darren, Steven * * * 2
5 * * 14/10/2009 * * * * *Reported * * * * * * * *Darren, Steven * * * * * 4
6 * * *15/10/2009 * * * * *Reported * * * * * * * *John, Darren * * * * * * *2
How can I average the numbers in column D, but only the ones in rows where A = October, B = reported and C contains "John"? (contains John, doesn't have to be exactly John). Note that there are some text strings in column D, so it is not all numbers - the answer for the example would be 4+2 divided by 2 = 3

* Thanks