excel - Activating Sumproduct Array (C+S+E) deactivates when workbook re-opened -

i've been scratching head few hours couple of time consuming issues. have sumproduct formula totalling number of bookings within month , year, , doing same totalling profit instead of number of bookings.

the formula each below:

bookings =sumproduct(--(bau!$x$3:$x$10000<>""),--(month(bau!$x$3:$x$10000)=1),--(year(bau!$x$3:$x$10000)=2013))  profit =sumproduct(--if(isnumber(bau!$aa$3:$aa$10000),bau!$aa$3:$aa$10000),--(month(bau!$x$3:$x$10000)=1),--(year(bau!$x$3:$x$10000)=2013)) 

two issues have, firstly, have 300 cells such formulas, these cover clients each month , each year, activating these control shift enter takes long time individually, when attempt activate of them @ once, month , year criteria in formulas e.g. (=1 & =2013) duplicated across every cell, instead of searching each month, every cells queries against =1 (january), can avoided?

secondly, after manually control shift entering every cell , saving/closing workbook, #value error in every cell when reopen it, meaning have repear whole cse process.

any appreciated, sorry if i've not made sense, tried best to.

if looks want

=countifs(bau!$x$3:$x$10000,">=1/1/2013",bau!$x$3:$x$10000,"<=1/31/2013") 

and

=sumifs(bau!$aa$3:$aa$10000,bau!$x$3:$x$10000,">=1/1/2013",bau!$x$3:$x$10000,"<=1/31/2013") 

you not need enter these arrays normal formulas.

if need change dates ever following:

in a1 (or ever cell you'd enter date in) right click cell , click format cells..., under "number" tab (usually tab open too) click on custom. enter "m/y" says type:.

from there enter month , year cell.

then modify formulas

=countifs(bau!$x$3:$x$10000,">="&a1,bau!$x$3:$x$10000,"<="&a1+30) 

and

=sumifs(bau!$aa$3:$aa$10000,bau!$x$3:$x$10000,">="&a1,bau!$x$3:$x$10000,"<="&a1+30) 

replace a1 cell choose enter date in. enter date "1/13" example.