Oct 31 2018 05:01 PM
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?
Oct 31 2018 05:48 PM
Nov 01 2018 01:07 AM
Nov 05 2018 08:03 AM
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.