Thread: Using SUMIF across multiple columns

I am using this code to look at a column and if it contains "READING" it will look for the corresponding position in CJ117 to CJ156 and add them all up.

=SUMIF($BS$6:$BS$45,"READING",(CJ$117:CJ$156))

The problem is that the word "READING" could appear cross eight columns, BS to BZ. I've had mixed success with the following formula, sometimes it works and sometimes it does'nt but I can't work out why. Is there a better way of doing it.

=SUMIF($BS$6:$BZ$45,"READING",(CJ$117:CJ$156))