Did you see the latest entry at David Gainer’s blog? Formula Autocomplete.
Finally, it will be possible to write a SUBTOTAL formula without consulting the Help! But one of the commenters makes a good point about the SUBTOTAL function:
So… please help me understand why you’re using a function number rather than just the name of a function. When we’re skimming through a sheet, or looking at a print out of formula view, we’ll have to have learned which numbers refer to which functions, won’t we? Or am I missing the point completely?