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="As ian"))*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


--
Tobro88
------------------------------------------------------------------------
Tobro88's Profile: http://www.excelforum.com/member.php...o&userid=28895
View this thread: http://www.excelforum.com/showthread...hreadid=490570

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))


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=490570

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


--
Tobro88
------------------------------------------------------------------------
Tobro88's Profile: http://www.excelforum.com/member.php...o&userid=28895
View this thread: http://www.excelforum.com/showthread...hreadid=490570