I didn't expect to use this for so long, but here I am.
So, those functions worked with hundreds of blank rows up to 524. I expected it to keep working when I increased that value. After all, it's just more blank rows like before. But now it's not happening.
Honestly, that's the only change, nothing else is different, nothing has changed from functionality to non-functionality other than referencing any # of rows over 524.
You are reporting formulas that look ok. In this type of situation, you may not be looking at the actual formulas in your worksheet. Look hard without assuming anything.
These are array formulas. Are you entering them with CTL-SHIFT-ENTER, as you should?
FrankBoston is the pen name for Andrew Garland, Lexington MA
I selected all the blank cells and cleared content. Then it worked fine. Maybe there was a cell with a formula or an entry that I couldn't see easily (a period?).
Thanks for the help folks.
even a space anywhere in J2:J529 would cause the formula to fail, you could try using a SUMPRODUCT formula where that wouldn't have such a catastrophic effect - and also doesn't need to be "array-entered"
=SUMPRODUCT(--(time1!$L$2:$L$529=$A77),--(time1!$H$2:$H$529=D$1),time1!$J$2:$J$529)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks