Hello all,

I've created a worksheet function that counts based on various conditions.
I got some help on these forums in creating it, and now I hope someone can
help solve a new problem.

The formula is: =SUMPRODUCT(--('Grindex
2008'!AB1:AB65535="Jan-2"),--('Grindex
2008'!Y1:Y65535="Jan-V"))+SUMPRODUCT(--('Grindex
2008'!AB1:AB65535="Jan-3"),--('Grindex 2008'!Y1:Y65535="Jan-V"))

Another individual is using the workbook, and the worksheet periodically
changes the function. It removes all the row numbers from my formula. And I
can't understand why it's happening.

The formula becomes this: =SUMPRODUCT(--('Grindex
2008'!AB:AB="Jan-2"),--('Grindex 2008'!Y:Y="Jan-V"))+SUMPRODUCT(--('Grindex
2008'!AB:AB="Jan-3"),--('Grindex 2008'!Y:Y="Jan-V"))

I've added the following Add-Ins: Conditional Sum Wizard, Solver Add-In.

I'm at a complete loss to explain the change. I set it back to the old
formula, then save and open it; it runs fine. If I leave it for a little
while (a few days to a week), then reopen it, it alters the formulas. I'm
hoping someone can see something I've done wrong, or a setting I need to
change. Any thoughts are appreciated.

Thanks,
Jay
--
Disregard, this is so I can find my post later.
***postedbyJay***