you could name your formula, then you could just insert the named
formula in the cells...
goto, insert,name,write a name,in the reference box enter your formula

then in the cells with the formula, enter =formulaname

another quick way would be to highlite the ranges that require the
formula, then write the formula, then instead of pressing enter, hit
Ctrl Enter then all the cells highlited will have the formula