Copy Paste Failure

[Tobro88]

I am creating a spreadsheet that tracks student performance based on
race. I am using an array. To save time I want to be able to paste my
formulas from one table to the next that is right below it.

The array that I am using is:
=SUM((I6:I28>=93%)*((I6:I28<=100%)*((C6:C28="Asian"))*1))

When I paste this formula about 10 rows down to break it down by
another race, my formula changes:
=SUM((I14:I36>=93%)*((I14:I36<=100%)*((C14:C36="Asian"))*1))

I thought that my cell range would stay the same. They change from
I6:I28 to
I14:I36. This is a considerable pain. I won't be able to finish my
sheet if I have to change the cell range every time I cut and paste.

Here is what the format of the cells looks like.


Asian Score Distribution Q1 Q2 Q3 Q4
Exemplary 93% or above 1 0 0 0
Advanced 87%-92% 0 0 0 0
Proficient 80%-86% 0 0 0 0
Basic 68%-79% 0 0 0 0
Unsatisfactory 67% & below 0 0 0 0
Total Tested 1 0 0 0

Af/Am Score Distribution Q1 Q2 Q3 Q4
Exemplary 93% or above 1 0 0 0
Advanced 87%-92% 0 0 0 0
Proficient 80%-86% 0 0 0 0
Basic 68%-79% 0 0 0 0
Unsatisfactory 67% & below 0 0 0 0
Total Tested 1 0 0 0

 

[duane]

start with this so the rows do not change when copied

=SUM((I$6:I$28>=93%)*((I$6:I$28<=100%)*((C$6:C$28="Asian "))*1))

 

[Tobro88]

Thanks Duane!! You rock!! I appreciate it.
Todd