Spreadsheet: 767454d1644484697-countif-with-multiple-criteria-example
Sheet: Reading

 |  | Reading
 |  | 1
STUDENT CODE | GRADE | FAMILY NAME | FIRST NAME | INTERVENTION | [NAME] |  |  | [NAME] |  |  |  | NAPLAN |  |  |  |  |  |  |  |  |  |  |  | Essential Assessment |  | Letter ID |  |  |  |  |  | PA | Word Tests |  |  |  |  | EOI | Reading Levels |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Oct - 2022 PAT Reading Test/Score | Oct - 2022 PAT Reading Result | Oct - Year 2 Reading NAPLAN Practice Test Score | May - Year 3 Reading NAPLAN Practice Test Score | May - Year 3 Reading NAPLAN Scale Score |  | May - Year 4 Reading NAPLAN Practice Test Score | Oct - Year 4 Reading NAPLAN Practice Test Score |  | May - Year 5 Reading NAPLAN Practice Test Score | May - Year 5 Reading NAPLAN Scale Score |  | May - Year 6 Reading NAPLAN Practice Test Score | Oct - Year 6 Reading NAPLAN Practice Test Score | Mar - Essential Literacy Assessment | Sep - Essential Literacy Assessment | Feb - Letter ID- (Upper/Lower Letter Name) | May - Letter ID- (Upper/Lower Letter Name) | Oct - Letter ID- (Upper/Lower Letter Name) | Feb - Letter ID- Sound | May - Letter ID- Sound | Oct - Letter ID- Sound | Feb - Phonological Awareness Test |  | May - Most Common 100 Words | Oct - Most Common 100 Words | May - BURT Word Test | Oct - BURT Word Test | Feb - English Online Interview |  | Feb - Benchmark (F&P) | [NAME] (F&P) | Sep - Benchmark (F&P) | Oct - Benchmark (F&P) | Sep - Running Record (seen text) |  | Semester 1 Growth |  | Semester 2 Growth
 |  |  |  | Example |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grades |  | Growth |  | Growth |  | Growth
 | 1MM |  |  |  |  | 0 |  |  |  |  | Towards Yr 6 + |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Semester 1 Growth |  |  |  |  |  | Semester 2 Growth |  |  |  |  |  | Whole Year Growth
 | 1AS |  |  |  |  | 0.5 |  |  |  |  | Towards Yr 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.5 | 1 | 1.5+ | Ave |  | 0 | 0.5 | 1 | 1.5+ | Ave |  | 0 | 0.5 | 1 | 1.5+ | Ave
 | 1DF |  |  |  |  | 0 |  |  |  |  | Towards Yr 4
 | 1MM |  |  |  |  | 0.5 |  |  |  |  | Towards Yr 3
 | 1AS |  |  |  |  | F |  |  |  |  | Towards Yr 2
 | 1DF |  |  |  |  | F |  |  |  |  | Towards Yr 1
 | 1DF |  |  |  |  | 0 |  |  |  |  | Towards F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUNE - Reading
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 0.5 | F | F.5 | 1 | 1.5 | 2 | 2.5 | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5 | 9 | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUNE - EAL Reading
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1.1 | A1.2 | A1.3 | A2.1 | A2.2 | A2.3 | B1.1 | B1.2 | B1.3 | B2.1 | B2.2 | B2.3 | B3.1 | B3.2 | B3.3 | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEC - Reading
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 0.5 | F | F.5 | 1 | 1.5 | 2 | 2.5 | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5 | 9 | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEC - EAL Reading
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1.1 | A1.2 | A1.3 | A2.1 | A2.2 | A2.3 | B1.1 | B1.2 | B1.3 | B2.1 | B2.2 | B2.3 | B3.1 | B3.2 | B3.3 | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Semester 1 Growth |  |  |  | Semester 2 Growth |  |  |  | Whole Year Growth
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gr | 0 | 0.5 | 1 | TOT | 0 | 0.5 | 1 | TOT | 0 | 0.5 | 1 | 1.5+ | TOT
 |  | Students that have left