If I insert a row above the formula, I can duplicate your problem.
Maybe the other user is inserting rows?

HTH-
JP


On Mar 18, 9:57*am, Jay wrote:
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***