I encountered an XLS file with this formula in some of its cells. I searched the web for information on the formula, but I couldn't find anything. Could you help?
The formula in question is:
=calcs!$E$31:$AH$31
I can't understand how it works.
I encountered an XLS file with this formula in some of its cells. I searched the web for information on the formula, but I couldn't find anything. Could you help? The formula in question is:
I can't understand how it works. 

The reason you can't find anything is that there's no such function. As noted in a comment, it looks like 


calcs
. Maybe a hidden one? This formula then is just specifying a range of cells on that worksheet. – jozzas Oct 4 '12 at 6:51