Also just another dilema, I have an array formula
=SUM(IF(MONTH('Quote Register'!$K$13:$K$257)=MONTH(Q$4),IF(YEAR('Quote Register'!$K$13:$K$257)=YEAR(Q$4),IF('Quote Register'!$L$13:$L$257=$B5,IF('Quote Register'!$E$13:$E$257=$D$2,'Quote Register'!$O$13:$O$257,IF($D$2="(ALL)",'Quote Register'!$O$13:$O$257,0)),0),0),0))

however when I add a new line in my sheet the formula moves from $K$13 to $K$14, how do I have it stay always at $K$13 when a new line is entered?

Thank you