SUBTOTAL vs LET vs STOCKHISTORY

Basic Classification Comparison

• Function Category 📊

  Primary classification of the Excel function based on its main purpose and usage domain, helps users quickly identify function types

  SUBTOTAL

  • Mathematical

    SUBTOTAL belongs to the Mathematical category. Excel functions for performing mathematical calculations Click to see all.

  LET

  • Engineering

    LET belongs to the Engineering category. Excel functions designed for engineering calculations and analysis Click to see all.

  STOCKHISTORY

  • Financial

    STOCKHISTORY belongs to the Financial category. Excel functions specifically designed for financial calculations and analysis Click to see all.

• Operation Type 🔧

  Fundamental type of operation or action that the Excel function performs on its inputs

  SUBTOTAL

  • Aggregation

    SUBTOTAL performs Aggregation operations. Excel functions for combining and summarizing data Click to see all.

  LET

  • Manipulation

    LET performs Manipulation operations. Functions that modify and transform data in different ways Click to see all.

  STOCKHISTORY

  • Information

    STOCKHISTORY performs Information operations. Functions that focus on retrieving and displaying data in various formats Click to see all.