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.

--
__________________________________
HTH

Bob

"IreneW" wrote in message
...
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))))}

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" wrote:

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.

--
__________________________________
HTH

Bob

"IreneW" wrote in message
...
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))))}

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))

--
__________________________________
HTH

Bob

"IreneW" wrote in message
...
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" wrote:

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.

--
__________________________________
HTH

Bob

"IreneW" wrote in message
...
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))))}

Thanks much, Bob. You are absolutely terrific.

I : )

"Bob Phillips" wrote:

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))

--
__________________________________
HTH

Bob

"IreneW" wrote in message
...
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" wrote:

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.

--
__________________________________
HTH

Bob

"IreneW" wrote in message
...
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))))}

=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.

=COUNTIF(O153:S550,A1)

--
__________________________________
HTH

Bob

<Jon Car wrote in message ...
=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.