If the ranges in your formula are correct then press F9, if it recalculates, then I would assume the calculation is set to manual,
if this is the case then go to tools, options calculate tab, make sure autocalculate is checked off