Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet Function Keeps Changing, need help
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*** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing worksheet direction | Excel Worksheet Functions | |||
Changing worksheet cells from within a function | Setting up and Configuration of Excel | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
changing font style in a complex worksheet function | Excel Worksheet Functions | |||
changing type style and colour within a worksheet function | Excel Worksheet Functions |