Hi everyone...I've been using the Sumproduct function for quite a while to
extract either the count of multiple criterias or the sum of multiple
criterias. I have a standard report I've been maintaining for a couple of
months now using the function.

When I attempted to update my report today, I get a #N/A error message for
all my formulas. I've checked my Add-ins to see if anything has been
deselected. And, I've recreated one of the formulas in a clean spreadsheet,
but I still get the message.

Is anyone else encountering this problem? And if so, has there been any
solutions?

Thanks in advance...
--
Danger Mouse