Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Links between two workbooks – dynamically using functions INDIRECT
  • MATCH fumction, just a simple search Lookup and References
  • Cells with additional spaces AND
  • Repeated Offset Basic Math
  • Cuts string of list of items Formulas - combined functions
  • Shapes with dynamic output Excel User tips
  • Count cells with condition – multiple conditions COUNTIFS
  • Fx to cut long column into two columns Formulas - combined functions

Sheet() and Sheets()

Posted on August 22, 2018 By ANmar

Getting total number of sheets (Sheets), or ID of this sheet (Sheet). The two new formulas Sheet() and Sheets() can do well, yes not perfect, we still need to have function to list sheet names, but it is a start

Sheets() function will get you total number of sheets (in this workbook or certain workbook)

While Sheet will only return the ID of this sheet among sheets in this workbook

Lookup and References, Standard functions, Worksheet Tags:SHEET, SHEETS

Post navigation

Previous Post: Worksheet name, dynamically using formula
Next Post: Skills Grid

Related Posts

  • Get 3rd Wednesday of month Basic Math
  • 0% interest promotion Basic Math
  • Sort list dynamically (functions) COLUMN
  • Scorring, saving multiple outputs in 1 number Basic Math
  • State Abbr with Index+Match+Validation Data Validation
  • Blank (isempty) VS “” (null string) Excel User tips

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (83)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (6)
      • Average (1)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Shapes with dynamic output Excel User tips
  • Limited Ceiling Basic Math
  • Return 12 values in one number AND
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • OFFSET+MATCH Formulas - combined functions
  • 0% interest promotion Basic Math
  • Insert Blank rows into table using functions CHAR
  • Expenses calendar, FaCal Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme