does anyone know if there is a way i can shorten this formula =SUMIF('1'!$D$12:$D$17,$A55,'1'!$C$12:$C$17)+SUMIF('2'!$D$12:$D$17,$A55,'2'!$C$12:$C$17)+SUMIF('3'!$D$12:$D$17,$A55,'3'!$C$12:$C$17)+SUMIF('4'!$D$12:$D$17,$A55,'4'!$C$12:$C$17)+SUMIF('5'!$D$12:$D$17,$A55,'5'!$C$12:$C$17)+SUMIF('6'!$D$12:$D$17,$A55,'6'!$C$12:$C$17)+SUMIF('7'!$D$12:$D$17,$A55,'7'!$C$12:$C$17)+SUMIF('8'!$D$12:$D$17,$A55,'8'!$C$12:$C$17)+SUMIF('9'!$D$12:$D$17,$A55,'9'!$C$12:$C$17)+SUMIF('10'!$D$12:$D$17,$A55,'10'!$C$12:$C$17)+SUMIF('11'!$D$12:$D$17,$A55,'11'!$C$12:$C$17)+SUMIF('12'!$D$12:$D$17,$A55,'12'!$C$12:$C$17)+SUMIF('13'!$D$12:$D$17,$A55,'13'!$C$12:$C$17)+SUMIF('14'!$D$12:$D$17,$A55,'14'!$C$12:$C$17)+SUMIF('15'!$D$12:$D$17,$A55,'15'!$C$12:$C$17)+SUMIF('16'!$D$12:$D$17,$A55,'16'!$C$12:$C$17)+SUMIF('17'!$D$12:$D$17,$A55,'17'!$C$12:$C$17)+SUMIF('18'!$D$12:$D$17,$A55,'18'!$C$12:$C$17)