# Thread: If then help (XP)

1. ## If then help (XP)

See attached, please. We have a large list of students showing all the classes they are failing. There is an entry for each class, by student. I need to write a formula that shows me which students are failing 3 or more classes so we can give them extra help. I'm stuck.

Thank you, in advance - again

Aunt Linda

2. ## Re: If then help (XP)

Enter the following formula in D2:
<code>
=SUMPRODUCT((\$A\$2:\$A\$12=A2)*(\$C\$2:\$C\$12="F"))>=3
</code>
and fill down to D12. The formula returns TRUE if the student in column A failed three or more classes, FALSE otherwise. Alternatively, you can use
<code>
=IF(SUMPRODUCT((\$A\$2:\$A\$12=A2)*(\$C\$2:\$C\$12="F"))>= 3,"Needs help!","")
</code>
This will return "Needs help!" if the student in column A failed three or more classes, a blank otherwise.

3. ## Re: If then help (XP)

Place the formula below in cell D2 and fill down to D12.

<code>
=SUMPRODUCT((A2=\$A\$2:\$A\$12)*1,(\$C\$2:\$C\$12="F")*1)
</code>

Column D now has the number of "F"s for the person named in column A. Is that what you want?

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•