Pete,

Try:

A1 contains your match product:

=IF((COUNTIF(B6:B19,A1)),AVERAGE(C6:C19),"")

Enter using Control-Shift-Enter as this is an array formula

HTH

" wrote:

I have 3 seperate ranges and would like to have an average from 3
columns depending on whether or not a specific product has been entered
in the following cells.

B6:B19
B27:B40
H6:H19

If one of the above cells="My Product" then I would like an average of
the following ranges

C6:C19
C27:C40
I6:I19

Can anyone give me a simple formula

Pete