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 |

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 |

1/21/2009 2:08:11 PM