Get
Digital
Help
More
  • Home
  • Functions
    Functions A to Z Functions by category
  • Formulas
  • Features
    Excel Basics Excel Defined Table Advanced Filter Data Validation Drop-down lists Named Ranges Solver
  • Charts
  • Conditional formatting
  • Pivot table
  • VBA
    VBA Functions Methods Properties Statements Macros User defined functions Files & folders Checkboxes
  • Archive
    All articles Products
  • Contact
    About me Blogs I read

    Misc

    How to decode URL-encoded strings

    Get the latest revision

    How to enter array formulas in merged cells

    Convert array formula to a regular formula

    Find positive and negative amounts that net to zero

    Sum cells with text

    Exact word in string

    Function Reference Formulas Charts Conditional Formatting Excel Tables Pivot Tables VBA Knowledge Base Macros User Defined Functions Videos Advanced Excel Course

    Most used functions

    COUNTIF function INDEX function IF function SUM function SUMIFS function SUMPRODUCT function VLOOKUP function


      • Formula categories

      Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup

  • Search website

Privacy PolicyNo AI