SUMPRODUCT/COUNTIF
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))))}
|