Hi there.
I have a cell that contains one long sumproduct formula. It is basically
combining 3 results into 1 cell with a "/" separating them. This formula is
repeated 448 times For the past week the formulas have worked great, but
today they only return "#N/A". My process for updating the data hasn't
changed nor has the data.

Now if I retype the formula and press enter, I get a correct result.

Why in the world is Excel forcing me to retype the exact same formula in the
exact same cell without any changes and then giving me a result? This is
immensly frustrating.

Any ideas?

--
Thanks,
Mike