I thought I understood the basic principles of SUMPRODUCT but when I add too
many criteria I completely lose track of the syntax - any help is appreciated.

Basically I have a number of named ranges that I want to check for multiple
criteria, and, at the end of the day, average. The ranges are as follows:

ErrorCheck (contains a number of different strings)
Group (contains a number of different strings)
Rating (contains a number, OR the word "Pass" OR the word "Fail")

How do I find the average of the numbers in Rating for which ErrorCheck =
"Yes," and Group = "Orange", and ignore the entries in Rating which are
strings?

Thanks,

Baybmech