Forum Discussion
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...
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..
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..
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.