Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passed Arguments to a UDF | Excel Worksheet Functions | |||
Qestion to judge whether the candidate has passed or failed ...... | New Users to Excel | |||
how do I fix a forecast date that has passed for a zero value? | Excel Discussion (Misc queries) | |||
formula to count number of months that have passed | Excel Discussion (Misc queries) | |||
Date Passed Notification | Excel Discussion (Misc queries) |