Invalid reference on data I can see! What gives?
I use a ton of SUMIFS and AVERAGEIFS formulae on a monster of a sports stats spreadsheet and it seems that since upgrading to Numbers 3.0, some references have been lost but not others. In other words, some of my SUMIFS and AVERAGEIFS work as expected and others not. For the ones that don't, however, I can SEE the data and there's nothing different about it in terms of format than what's in the formulae that works. I don't understand why Numbers can't see the columns I'm seeing it. What is going on here? Could it be that the columns are very far "east," like in the FJ to IJ range? Could this be user error on my part?
MacBook Pro 2.8 GHz