Average from different sheets in workbook

[90paulwilson]

Hi all,

I'm trying to create a 'summary' type page of information for my school's PE data. The formula I've tried is:

=SUM(COUNTIFS('Year 5'!C2:C30, “=Y”, 'Year 5'!F2:F30, {"EXS","GDS"}))/COUNTIF('Year 5'!C2:C30, “=Y”)

I was hoping this would tell me who passed the 'effort' category and was also classified as a PP child and give me the information as a percentage. This is the information I need for C3 on the summary page but it doesn't seem to be correct.

Could somebody tell me where I'm going wrong please?

Thanks in advance.

Paul

[Glenn Kennedy]

I used this, which worked fine, giving 0.7, which - when formatted as a % gives 70:


=SUM(COUNTIFS('Year 5'!C2:C30, "Y", 'Year 5'!F2:F30, {"EXS","GDS"}))/COUNTIF('Year 5'!C2:C30, "Y")

There's no need for the = and I don't know what sort of " you were using, but the ones in the post were slanted. Unfortunately, the file you posted was formula-free...

[90paulwilson]

Ah thank you. Perhaps I was using the incorrect ".

Thanks again.

[Glenn Kennedy]

I think so... a bit puzzling, as on my laptop KB, there's only the striaght ones.... Odd.

Anyhow, you're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.