SUMPRODUCT/COUNTIF

  • Thread starter Thread starter IreneW
  • Start date Start date
I

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))))}
 
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.
 
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.
 
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))
 
=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.
 
Back
Top