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