• 542K Members
• 7,799 Online
• 646K Conversations

Highlighted
New Contributor

# Formula

I need help creating a formula that will take information from particular cells if they have an X "certain people" from a list of data of students and calculate the pass rate.

Basically if they have an X in column C, take their data from Column E, F, G.... and calculate if they passed or not.

Is it possible?

3 Replies
Highlighted

# Re: Formula

kindly attach a mock-sheet, indicate there what you need.
place sample data where to do what - and expected result.
with that, people here at the forum can have a better view of your query and maybe offer some solutions.
thanks..
Highlighted

# Re: Formula

Asmahan, to add to what Lorenzo said.
Checking column C for X is easy, please explain what you mean by "take their data".
Is it multiplying or dividing something, for example?
Also, to calculate "passed or not" we need to know the passing grade.

# Re: Formula

Thank you.  I've attached a sample document.

So in the document at the bottom, you can see that I'm trying to figure out the students that are labeled SPED - their pass rate.  Also, the students who are labeled as ESOL, what their pass rate is as well.  I came up with a formula but its not an easy one.  A pain in the butt to copy to other spreadsheets and also it doesn't just copy, I have to fix the cell its calculating from.

I hope this makes sense.

Related Conversations
Leap year formula
Hattsoff in Excel on
4 Replies
FORMULAS
aayushman_mishra in Excel on
4 Replies
formula for data calculation
aayushman_mishra in Excel on
10 Replies