Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct with multiple criteria and both numbers and strings
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count using multiple criteria including text strings | Excel Worksheet Functions | |||
SUMPRODUCT / SUMIF on Multiple Worksheets with Multiple Criteria | Excel Discussion (Misc queries) | |||
Sumproduct multiple criteria | Excel Worksheet Functions | |||
SUMPRODUCT USING WORDS AS WELL AS NUMBERS FOR CRITERIA | Excel Worksheet Functions | |||
Using Sumproduct with multiple Criteria | Excel Worksheet Functions |