count passed or failed
 

im having a problem getting the correct formula for this one. i used
=IF((DATA!$G$2:$G$5000-DATA!$F$2:$F$5000)=(DATA!$K$2:$K$5000-DATA!$J$2:$J$5000),"Passed","Failed")
and =COUNTIF(DATA!$L$2:$L$5000, ") and it gave me the desired
output. but the problem is, i have to get the total number of passed and
failed for each person in my team. i can't seem to find the exact formula to
combine those conditions.

please help me, thanks!

count passed or failed
 

Neri,

=SUMPRODUCT(((DATA!$G$2:$G$5000-DATA!$F$2:$F$5000)= (DATA!$K$2:$K$5000-DATA!$J$2:$J$5000))
"))

Take out any line breaks that your news reader or web interface puts in...

HTH,
Bernie
MS Excel MVP


"Neri" wrote in message
...
im having a problem getting the correct formula for this one. i used
=IF((DATA!$G$2:$G$5000-DATA!$F$2:$F$5000)=(DATA!$K$2:$K$5000-DATA!$J$2:$J$5000),"Passed","Failed")
and =COUNTIF(DATA!$L$2:$L$5000, ") and it gave me the desired
output. but the problem is, i have to get the total number of passed and
failed for each person in my team. i can't seem to find the exact formula to
combine those conditions.

please help me, thanks!

count passed or failed
 

Ooops.

And for failed, change the = to <:

=SUMPRODUCT(((DATA!$G$2:$G$5000-DATA!$F$2:$F$5000)< (DATA!$K$2:$K$5000-DATA!$J$2:$J$5000))
"))

HTH,
Bernie
MS Excel MVP


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Neri,

=SUMPRODUCT(((DATA!$G$2:$G$5000-DATA!$F$2:$F$5000)= (DATA!$K$2:$K$5000-DATA!$J$2:$J$5000))
"))

Take out any line breaks that your news reader or web interface puts in...

HTH,
Bernie
MS Excel MVP


"Neri" wrote in message
...
im having a problem getting the correct formula for this one. i used
=IF((DATA!$G$2:$G$5000-DATA!$F$2:$F$5000)=(DATA!$K$2:$K$5000-DATA!$J$2:$J$5000),"Passed","Failed")
and =COUNTIF(DATA!$L$2:$L$5000, ") and it gave me the desired
output. but the problem is, i have to get the total number of passed and
failed for each person in my team. i can't seem to find the exact formula to
combine those conditions.

please help me, thanks!

count passed or failed
 

You're so great! Thank you very much! :)



"Bernie Deitrick" wrote:

Ooops.

And for failed, change the = to <:

=SUMPRODUCT(((DATA!$G$2:$G$5000-DATA!$F$2:$F$5000)< (DATA!$K$2:$K$5000-DATA!$J$2:$J$5000))
"))

HTH,
Bernie
MS Excel MVP


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Neri,

=SUMPRODUCT(((DATA!$G$2:$G$5000-DATA!$F$2:$F$5000)= (DATA!$K$2:$K$5000-DATA!$J$2:$J$5000))
"))

Take out any line breaks that your news reader or web interface puts in...

HTH,
Bernie
MS Excel MVP


"Neri" wrote in message
...
im having a problem getting the correct formula for this one. i used
=IF((DATA!$G$2:$G$5000-DATA!$F$2:$F$5000)=(DATA!$K$2:$K$5000-DATA!$J$2:$J$5000),"Passed","Failed")
and =COUNTIF(DATA!$L$2:$L$5000, ") and it gave me the desired
output. but the problem is, i have to get the total number of passed and
failed for each person in my team. i can't seem to find the exact formula to
combine those conditions.

please help me, thanks!