SUMPRODUCT/COUNTIF

[IreneW]

I'm trying to get the percentage of times that an is able to meet assigned
goals accross multiple rows and columns. What I've come up with after more
time than I care to admit is below. Cany anyone help me with this?

={SUMPRODUCT(($C$2:$C$34="Persons
Name")*($E$2:$E$34<F2:F34)*($I$2:$I$34<$J$2:$J$34*(M2:M34<N2:N34)/COUNT(IF(($C$2:$C$34="Persons Name"),$E$2:$F34,I2:I34,M2:M34))))}

 

[Bob Phillips]

You will need to give us a lot more explanation as to what your goal is,
what the data looks like, what expected results are etc., that formula is
almost indecipherable.

 

[IreneW]

Thanks much Bob for helping me along with this.

What I'm trying to do is take the goals set for each person and come up with
a % or time that the person fails or achieves goal depending on how one looks
at it.

In column C I have the names of each person; in column E there is a number
representing the number of parts that a person should be able to do each
night; the next column (F) is a number representing the number of parts
actually done. I have the spreadsheet set up so that columns E, I and M are
contain respective goals for each part; columns F, J and N contain the
repective actual number of parts built. I'm looking for the % of time that a
person actually makes goal. Does this help at all?

Again, thanks much.

 

[Bob Phillips]

How about this?

=SUMPRODUCT(($C$2:$C$34="Joe")*($F$2:$F$34+$J$2:$J$34+$N$2:$N$34))/
SUMPRODUCT(($C$2:$C$34="Joe")*($E$2:$E$34+$I$2:$I$34+$M$2:$M$34))

 

[IreneW]

Thanks much, Bob. You are absolutely terrific.

I : )

 

[Jon Car]

=SUMPRODUCT(COUNTIF(O153:S550,{"Unknown"}),{1}) I want to know if I could put a cell value instead of entering a word where unknown is? Any help is appreciated. thank you.

 

[Bob Phillips]

=COUNTIF(O153:S550,A1)