Can't think what Function you are looking for.

SUMPRODUCT, INDIRECT, SUBTOTAL?

Download Peter Noneley's workbook from this site.

http://www.xlfdic.com/

Very good examples and usage of all the Excel Functions.


Gord Dibben MS Excel MVP

On 11 Feb 2007 16:42:56 -0800, "
wrote:

I have two questions.

First, what is the name of the function that computes other functions
"indirectly"?

As I recall, it is something like SUBFUNCTION(funcNumber, funcArgs).
Obviously, SUBFUNCTION is the wrong name.

Second, how can I get a comprehensive list of Excel functions using
Excel Help (perhaps), either alphabetically or by category?

I know that if I enter a "similar" function name in Excel Help, Show
All gives me the option of getting a list of related functions in a
category. But I was unable to think of a function similar to what I
call SUBFUNCTION. I would have been content with exhaustively
searching a list of all Excel functions. But I was unable to get that
comprehensive list.