Get
Digital
Help
More
  • Home
  • Functions
  • 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 sorted by date Categories Products
  • Contact
    About me Blogs I read
    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



Categories


  • Categories
    • Excel (1,150)
      • Add-in (4)
      • Basic formulas (88)
        • Count (11)
        • Dates (15)
        • Extract (10)
        • INDEX + MATCH (7)
        • Logic (9)
        • Lookups (8)
        • Small (8)
        • Sum (15)
        • Text string manipultion (3)
        • Time (3)
      • Blank cells (5)
      • Calendar (16)
      • Case sensitive (3)
      • Charts (92)
        • 100% stacked column chart (1)
        • Animate (3)
        • Area chart (1)
        • Bar chart (2)
        • Box and whisker chart (1)
        • Bubble chart (1)
        • Candlestick chart (1)
        • Chart basics (7)
        • Chart elements (16)
        • Column chart (6)
        • Combination chart (3)
        • Custom charts (6)
        • Data labels (1)
        • Doughnut chart (1)
        • Funnel chart (1)
        • Gantt (2)
        • Highlight (5)
        • Histogram chart (1)
        • Interactive (10)
        • Line chart (4)
        • Map chart (1)
        • Pareto chart (1)
        • Pie chart (1)
        • Radar chart (1)
        • SCATTER (x y) chart (8)
        • Sparkline (3)
          • Column (1)
          • Line (1)
          • Win/loss (1)
        • STACKED COLUMN chart (1)
        • stock chart (4)
        • Sunburst chart (1)
        • Surface chart (1)
        • Treemap chart (1)
        • Waterfall chart (1)
      • Combinations (2)
      • Combine Merge (9)
      • Compare (16)
      • Concatenate (5)
      • Conditional formatting (54)
        • CF-basic-formulas (4)
        • CF-built-in (3)
        • CF-compare (6)
        • CF-dates (9)
        • CF-duplicates (9)
        • CF-min-max (3)
        • CF-misc (6)
        • CF-search (4)
        • CF-unique-distinct (4)
        • Highlight Cells Rules (4)
        • Highlight duplicates (1)
        • Top/Bottom Rules (3)
      • Count unique distinct records (1)
      • Count values (33)
        • Count text values (2)
        • Count unique distinct values (6)
      • COUNTIF (1)
      • Dates (46)
        • Overlapping (17)
      • Duplicate records (1)
      • Duplicate values (16)
      • Excel Basics (16)
      • Features (80)
        • Advanced filter (6)
        • Data validation (28)
          • Drop down lists (25)
            • Dependent drop down lists (6)
        • Excel table (22)
        • Named range (5)
        • Pivot table (16)
        • Solver (7)
      • Filter emails (2)
      • Filter records (9)
      • Finance (15)
        • Stock market trend (5)
        • Stock portfolio (5)
      • Find numbers in sum (5)
      • Formula characters (1)
      • Functions (891)
        • Array manipulation (32)
          • CHOOSECOLS function (1)
          • CHOOSEROWS function (1)
          • DROP function (3)
          • EXPAND function (1)
          • HSTACK function (2)
          • TAKE function (1)
          • TOCOL function (16)
          • TOROW function (2)
          • VSTACK function (9)
          • WRAPCOLS function (1)
          • WRAPROWS function (1)
        • Compatibility (23)
          • BETADIST function (1)
          • BETAINV function (1)
          • BINOMDIST function (1)
          • CHIDIST function (1)
          • CHIINV function (1)
          • CHITEST function (1)
          • CONFIDENCE (1)
          • COVAR function (1)
          • CRITBINOM function (1)
          • EXPONDIST function (1)
          • FDIST function (1)
          • FLOOR function (1)
          • FORECAST function (1)
          • FTEST function (1)
          • GAMMADIST function (1)
          • LOGNORMDIST function (1)
          • MODE function (1)
          • PERCENTRANK function (1)
          • QUARTILE function (1)
          • RANK function (3)
          • STDEV function (1)
        • Database (11)
          • DAVERAGE function (1)
          • DCOUNT function (1)
          • DGET function (1)
          • DMAX function (1)
          • DMIN function (1)
          • DOUNTA function (1)
          • DPRODUCT function (1)
          • DSTDEV function (1)
          • DSTDEVP function (1)
          • DSUM function (1)
          • DVARP function (1)
        • Date and Time (88)
          • DATE function (30)
          • DATEDIF function (4)
          • DATEVALUE function (3)
          • DAY function (10)
          • DAYS function (1)
          • EDATE function (2)
          • EOMONTH function (2)
          • HOUR function (5)
          • MINUTE function (2)
          • MONTH function (29)
          • NETWORKDAYS function (2)
          • NETWORKDAYS.INTL function (2)
          • NOW function (2)
          • SECOND function (2)
          • TIME function (7)
          • TIMEVALUE function (1)
          • TODAY function (9)
          • WEEKDAY function (15)
          • WEEKNUM function (5)
          • WORKDAY function (2)
          • YEAR function (27)
          • YEARFRAC function (1)
        • Engineering (45)
          • BIN2DEC function (2)
          • BIN2HEX function (1)
          • BIN2OCT function (1)
          • BITAND function (1)
          • BITLSHIFT function (1)
          • BITOR function (1)
          • BITRSHIFT function (1)
          • BITXOR function (2)
          • COMPLEX function (1)
          • CONVERT function (1)
          • DEC2BIN function (2)
          • DEC2HEX function (2)
          • DEC2OCT function (1)
          • DELTA function (1)
          • HEX2BIN function (1)
          • HEX2DEC function (3)
          • HEX2OCT function (1)
          • IMABS function (2)
          • IMAGINARY function (1)
          • IMARGUMENT function (1)
          • IMCONJUGATE function (1)
          • IMCOS function (1)
          • IMCOSH function (1)
          • IMCOT function (1)
          • IMCSC function (1)
          • IMCSCH function (1)
          • IMDIV function (1)
          • IMEXP function (1)
          • IMLN (1)
          • IMLOG10 function (1)
          • IMLOG2 function (1)
          • IMPOWER function (1)
          • IMPRODUCT function (1)
          • IMREAL function (1)
          • IMSEC function (1)
          • IMSECH function (1)
          • IMSIN function (1)
          • IMSINH function (1)
          • IMSQRT function (1)
          • IMSUB function (1)
          • IMSUM function (1)
          • IMTAN function (1)
        • Financial (29)
          • ACCRINT function (1)
          • ACCRINTM function (1)
          • AMORDEGRC function (1)
          • AMORLINC function (1)
          • CUMIPMT function (1)
          • CUMPRINC function (1)
          • DB function (1)
          • DDB function (1)
          • DOLLARFR function (1)
          • EFFECT function (1)
          • FV function (1)
          • IPMT function (1)
          • ISPMT function (1)
          • NOMINAL function (1)
          • NPER function (1)
          • PDURATION function (1)
          • PMT function (1)
          • PPMT function (1)
          • PRICEMAT function (1)
          • PV Function (1)
          • RATE function (1)
          • RRI function (1)
          • SYD function (1)
          • TBILLEQ function (1)
          • TBILLPRICE function (1)
          • TBILLYIELD function (1)
          • VDB function (1)
          • XNPV function (1)
          • YIELD function (1)
        • Information (92)
          • CELL function (2)
          • ERROR.TYPE function (1)
          • INFO function (1)
          • ISBLANK function (9)
          • ISERR function (1)
          • ISERROR function (26)
          • ISFORMULA function (2)
          • ISLOGICAL function (1)
          • ISNA function (3)
          • ISNONTEXT function (1)
          • ISNUMBER function (35)
          • ISODD function (1)
          • ISREF function (1)
          • ISTEXT function (9)
          • N function (1)
          • NA function (3)
          • SHEET function (1)
          • SHEETS function (1)
          • TYPE function (1)
        • Logical (347)
          • AND function (8)
          • BYCOL function (1)
          • BYROW function (1)
          • FALSE function (29)
          • IF function (277)
          • IFERROR function (94)
          • IFNA function (5)
          • IFS function (1)
          • ISEVEN funtion (1)
          • LAMBDA function (7)
          • MAKEARRAY function (1)
          • MAP function (1)
          • NOT function (19)
          • OR function (13)
          • REDUCE function (4)
          • SCAN function (2)
          • SWITCH function (3)
          • TRUE function (57)
          • XOR function (1)
        • Lookup and reference (394)
          • ADDRESS function (5)
          • AREAS function (1)
          • CHOOSE function (6)
          • COLUMN function (63)
          • COLUMNS function (36)
          • FILTER function (67)
          • FORMULATEXT function (1)
          • HLOOKUP function (1)
          • HYPERLINK function (9)
          • INDEX function (234)
          • INDIRECT function (29)
          • LOOKUP function (34)
            • Lookup numerical ranges (1)
          • MATCH function (216)
          • OFFSET function (22)
          • ROW function (187)
          • ROWS function (98)
          • SORT function (17)
          • SORTBY function (15)
          • STOCKHISTORY function (2)
          • TRANSPOSE function (43)
          • UNIQUE function (38)
          • VLOOKUP function (11)
          • XLOOKUP function (3)
          • XMATCH function (1)
        • Math and trigonometry (289)
          • ABS function (14)
          • ACOS function (1)
          • ACOSH function (1)
          • ACOT function (1)
          • ACOTH function (1)
          • AGGREGATE function (7)
          • ASIN function (1)
          • ASINH function (1)
          • ATAN function (1)
          • ATAN2 function (1)
          • ATANH function (1)
          • BASE function (2)
          • CEILING function (1)
          • COMBIN function (2)
          • COMBINA function (1)
          • COS function (1)
          • COSH function (1)
          • COT function (1)
          • COTH function (1)
          • CSC function (1)
          • DECIMAL function (1)
          • DEGREES function (2)
          • EVEN function (2)
          • EXP function (1)
          • FACT function (7)
          • FACTDOUBLE function (1)
          • FLOOR.MATH function (1)
          • FLOOR.PRECISE function (1)
          • GCD function (1)
          • GDC function (1)
          • INT function (11)
          • LCM function (1)
          • LET function (42)
          • LN function (1)
          • LOG function (1)
          • LOG10 function (2)
          • MINVERSE function (2)
          • MMULT function (30)
          • MOD function (14)
          • MROUND function (1)
          • MULTINOMIAL function (1)
          • MUNIT function (1)
          • PI function (2)
          • POWER function (4)
          • PRODUCT function (2)
          • QUOTIENT function (4)
          • RADIANS function (2)
          • RAND function (3)
          • RANDARRAY function (2)
          • RANDBETWEEN function (13)
          • ROUND function (4)
          • ROUNDDOWN function (5)
          • ROUNDUP function (5)
          • SEC function (1)
          • SECH function (1)
          • SEQUENCE function (28)
          • SERIESSUM function (1)
          • SIGN function (3)
          • SIN function (1)
          • SINH function (1)
          • SQRT function (1)
          • SUBTOTAL function (14)
          • SUM function (58)
          • SUMIF function (6)
          • SUMIFS function (7)
          • SUMPRODUCT function (80)
          • SUMSQ function (1)
          • SUMX2MY2 function (1)
          • SUMX2PY2 function (1)
          • SUMXMY2 function (1)
          • TAN function (1)
          • TANH function (1)
          • TRUNC function (1)
        • Statistical (410)
          • AVEDEV function (1)
          • AVERAGE function (10)
          • AVERAGEA function (1)
          • AVERAGEIF function (3)
          • AVERAGEIFS function (1)
          • BETA.DIST function (1)
          • BETA.INV function (1)
          • BINOM.DIST function (1)
          • BINOM.INV function (1)
          • CHISQ.DIST function (1)
          • CHISQ.DIST.RT function (1)
          • CHISQ.INV function (1)
          • CHISQ.INV.RT function (1)
          • CHISQ.TEST function (1)
          • CONFIDENCE.NORM (1)
          • CONFIDENCE.T function (1)
          • CORREL function (1)
          • COUNT function (10)
          • COUNTA function (21)
          • COUNTBLANK function (2)
          • COUNTIF function (160)
          • COUNTIFS function (54)
          • COVARIANCE.P function (1)
          • COVARIANCE.S function (1)
          • EXPON.DIST function (1)
          • F.DIST function (1)
          • F.DIST.RT (1)
          • F.TEST function (1)
          • FORECAST.LINEAR function (1)
          • FREQUENCY function (20)
          • GAMMA function (1)
          • GAMMA.DIST function (1)
          • GEOMEAN function (1)
          • GROWTH function (1)
          • HYPGEOM.DIST function (1)
          • INTERCEPT function (2)
          • LARGE function (27)
          • LINEST function (1)
          • LOGEST function (1)
          • LOGNORM.DIST function (1)
          • MAX function (33)
          • MAXIFS function (5)
          • MEDIAN function (3)
          • MIN function (58)
          • MINA function (1)
          • MINIFS function (8)
          • MODE.MULT function (1)
          • MODE.SNGL function (2)
          • NORM.DIST function (2)
          • NORM.INV function (1)
          • PERCENTRANK.EXC function (1)
          • PERCENTRANK.INC function (1)
          • PERMUT function (8)
          • PERMUTATIONA function (3)
          • PHI function (1)
          • PROB function (1)
          • QUARTILE.EXC function (1)
          • QUARTILE.INC function (1)
          • RANK.AVG function (1)
          • RANK.EQ function (1)
          • SKEW function (1)
          • SLOPE function (2)
          • SMALL function (140)
          • STANDARDIZE function (1)
          • STDEV.P (1)
          • STDEV.S function (1)
          • STDEVA function (1)
          • STDEVPA function (1)
          • TREND function (1)
          • TRIMMEAN function (1)
          • VAR.P function (1)
          • VAR.S function (1)
        • Text (151)
          • ARRAYTOTEXT Function (1)
          • ASC function (1)
          • CHAR function (9)
          • CLEAN function (1)
          • CODE function (5)
          • CONCAT function (2)
          • CONCATENATE function (2)
          • EXACT function (9)
          • FIND function (8)
          • LEFT function (14)
          • LEN function (29)
          • LOWER function (1)
          • MID function (22)
          • REPLACE function (1)
          • REPT function (6)
          • RIGHT function (8)
          • SEARCH function (37)
          • SUBSTITUTE function (15)
          • T function (1)
          • TEXT function (24)
          • TEXTAFTER function (2)
          • TEXTBEFORE function (1)
          • TEXTJOIN function (36)
          • TEXTSPLIT function (14)
          • TRIM function (12)
          • UNICHAR function (1)
          • UNICODE function (1)
          • UPPER function (4)
          • VALUE function (1)
          • VALUETOTEXT function (1)
        • Web (9)
          • ENCODEURL function (1)
          • FILTERXML function (6)
          • IMAGE function (1)
          • WEBSERVICE function (1)
      • Fuzzy lookup (2)
      • Hyperlinks (9)
      • IF (3)
      • Invoice (7)
      • Maps (3)
      • Mathematics (2)
        • Complex numbers (1)
      • Maze (3)
      • Misc (7)
      • Missing values (8)
      • Normalize data (2)
      • Pathfinding (3)
      • PDF (1)
      • Permutations (9)
      • Random (10)
        • Team generator (3)
      • Rank (3)
      • Rearrange values (5)
      • Records (9)
      • Relational tables (7)
      • Schedule (12)
      • Search and return multiple values (13)
        • Wildcard Search (1)
      • Sequence (7)
      • Sort values (25)
      • Split values (7)
      • Substitute Replace (1)
      • SUMPRODUCT (5)
      • Templates (16)
      • Text string manipulation (3)
      • Tournament (2)
      • Two-dimensional lookup (6)
      • Unique distinct records (8)
      • Unique distinct values (33)
      • Unique values (11)
        • Range (1)
      • VBA (160)
        • Arrays (3)
        • Check-boxes (6)
        • Combobox (5)
        • Dialog boxes (1)
        • Files and folders (14)
        • Form Controls (6)
          • Scroll bar (1)
        • Functions (7)
          • ARRAY function (1)
          • Fix Function (1)
          • INT function (1)
          • JOIN function (1)
          • Lbound Ubound function (1)
          • SGN function (1)
          • SPLIT function (1)
        • Listbox (3)
        • Macro (78)
        • Methods (3)
          • Evaluate method (1)
          • Range.Find method (1)
          • TextToColumns method (1)
        • Print (5)
        • Properties (1)
          • RANGE.OFFSET property (1)
        • Recursive (1)
        • Regular expressions (4)
        • Statements (19)
          • DO LOOP statement (1)
          • FOR NEXT statement (6)
          • GoTo statement (1)
          • IF THEN ELSE statement (6)
          • SELECT CASE statement (1)
          • SET statement (1)
          • WITH … END WITH Statement (4)
        • Text boxes (1)
        • User Defined Function (32)
        • Worksheet (2)
      • VLOOKUP (4)
      • VLOOKUP and return multiple values (14)
      • XLOOKUP (1)
  • Comments Off on Categories

    Comments are closed.

    How to comment

    How to add a formula to your comment
    <code>Insert your formula here.</code>

    Convert less than and larger than signs
    Use html character entities instead of less than and larger than signs.
    < becomes &lt; and > becomes &gt;

    How to add VBA code to your comment
    [vb 1="vbnet" language=","]
    Put your VBA code here.
    [/vb]

    How to add a picture to your comment:
    Upload picture to postimage.org or imgur
    Paste image link to your comment.

    Contact Oscar

    You can contact me through this contact form


      • Formula categories

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

    Privacy Policy