Hi guys,

I have 3 columns. Column A contains the category lables "cat",
"dog","goldfish","mouse", column B contains a further category lable, ie 1,
2, 3, or 4 depending on their assigned grade, and column C contains a
variable value.

I need to average the variable values in column C only if they meet two of
the specific criteria in Columns A and B.

For example only average the values in column C where Column A contains cat
and column B contains the number 1.

The people on this forum have been invaluable to me for my problems with
excel so many thanks in advance.

kind regards,

Ant