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, "name@email.com") 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!
0
Neri (3)
1/21/2009 12:33:00 PM
excel.newusers 15348 articles. 2 followers. Follow

3 Replies
644 Views

Similar Articles

[PageSpeed] 19

Neri,

=SUMPRODUCT(((DATA!$G$2:$G$5000-DATA!$F$2:$F$5000)= (DATA!$K$2:$K$5000-DATA!$J$2:$J$5000)) 
*(DATA!$L$2:$L$5000="name@email.com"))

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

HTH,
Bernie
MS Excel MVP


"Neri" <Neri@discussions.microsoft.com> wrote in message 
news:28582957-FF32-4F99-B9FE-CE1CBA93FC43@microsoft.com...
> 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, "name@email.com") 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! 


0
Bernie
1/21/2009 1:55:01 PM
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))
*(DATA!$L$2:$L$5000="name@email.com"))

HTH,
Bernie
MS Excel MVP


"Bernie Deitrick" <deitbe @ consumer dot org> wrote in message 
news:em$eZ$8eJHA.5724@TK2MSFTNGP02.phx.gbl...
> Neri,
>
> =SUMPRODUCT(((DATA!$G$2:$G$5000-DATA!$F$2:$F$5000)= (DATA!$K$2:$K$5000-DATA!$J$2:$J$5000)) 
> *(DATA!$L$2:$L$5000="name@email.com"))
>
> Take out any line breaks that your news reader or web interface puts in...
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "Neri" <Neri@discussions.microsoft.com> wrote in message 
> news:28582957-FF32-4F99-B9FE-CE1CBA93FC43@microsoft.com...
>> 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, "name@email.com") 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!
>
> 


0
Bernie
1/21/2009 2:08:11 PM
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))
> *(DATA!$L$2:$L$5000="name@email.com"))
> 
> HTH,
> Bernie
> MS Excel MVP
> 
> 
> "Bernie Deitrick" <deitbe @ consumer dot org> wrote in message 
> news:em$eZ$8eJHA.5724@TK2MSFTNGP02.phx.gbl...
> > Neri,
> >
> > =SUMPRODUCT(((DATA!$G$2:$G$5000-DATA!$F$2:$F$5000)= (DATA!$K$2:$K$5000-DATA!$J$2:$J$5000)) 
> > *(DATA!$L$2:$L$5000="name@email.com"))
> >
> > Take out any line breaks that your news reader or web interface puts in...
> >
> > HTH,
> > Bernie
> > MS Excel MVP
> >
> >
> > "Neri" <Neri@discussions.microsoft.com> wrote in message 
> > news:28582957-FF32-4F99-B9FE-CE1CBA93FC43@microsoft.com...
> >> 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, "name@email.com") 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!
> >
> > 
> 
> 
> 
0
Neri (3)
1/21/2009 2:40:03 PM
Reply:

Similar Artilces: