Hello!

I'm not quite sure what I did, but while doing a lot of =SUMPRODUCT and =COUNTIF formulas, I just have managed to hit some kind of button combination to de-activate some default settings; as I mostly think it is tied to the 'Cell Category' to something non-standard, but which I have already attempted to change manually numerous times.

Anytime I try to use the SUMPRODUCT or COUNTIF formula to compute something very simple, and something I know is true, it always returns a '0' or'#VALUE' error. I've even copied and pasted basic examples from Excel Help, as well as copied and pasted the answer it tells you and it gives me a '0' (when it clearly isn't).

Any help? I know I screwed something stupid up!

Thanks