AntBlabby8
Board Regular
- Joined
- Apr 18, 2002
- Messages
- 195
I have several worksheets each with the same analysis except the product is different. But the same formulas are in all of them, in the same place. In one column, there is an IF formula that says, if in another column there a number is at a certain level, than bring in the number, otherwise put "NO RIGHTS" in the cell. Then, I have a SUMIF below the table that sums another column based on whether a result in a given row says "NO RIGHTS" in that column. On 20 of 28 sheets, the SUMIF works great. On 8 sheets, I get a WRONG result, with some numbers being left out of the sum. The formula is identical, since each sheet was based on a template. Does anyone know what would cause this or the routine to go through to check for a problem so that they all work? Otherwise, i will have to go back to a super long chain of IFs added together and might even exceed the number of arguments allowed in which case I am totally screwed! Any ideas?