Get Digital Help
  • Home
  • Functions
  • Formulas
  • Charts
  • CF
  • Pivot tables
  • VBA
  • Archive
  • Contact

    Excel functions

    Compatibility

    BETADIST function

    BETAINV function

    BINOMDIST

    CHIDIST function

    CHIINV function

    CHITEST function

    CONFIDENCE

    COVAR function

    CRITBINOM

    EXPONDIST

    FDIST function

    FLOOR function

    MODE function

    RANK function

    STDEV function

    Database

    DAVERAGE function

    DCOUNT function

    DCOUNTA function

    DGET function

    DMAX function

    DMIN function

    DPRODUCT function

    DSTDEV function

    DSTDEVP function

    DSUM function

    DVARP function

    Date and Time

    DATE function

    DATEDIF function

    DATEVALUE

    DAY function

    DAYS function [2013]

    EDATE function

    EOMONTH function

    HOUR function

    MINUTE function

    MONTH function

    NETWORKDAYS

    NOW function

    SECOND function

    TIME function

    TIMEVALUE

    TODAY function

    WEEKDAY function

    WORKDAY function

    YEAR function

    YEARFRAC function

    Engineering

    BIN2DEC function

    BIN2HEX function

    BIN2OCT function

    BITAND function [2013]

    BITLSHIFT [2013]

    BITOR function [2013]

    BITRSHIFT [2013]

    BITXOR function [2013]

    COMPLEX function

    CONVERT function

    DEC2BIN function

    DEC2HEX function

    DEC2OCT function

    DELTA function

    Financial

    ACCRINT function

    ACCRINTM function

    CUMIPMT function

    CUMPRINC function

    DB function

    DOLLARFR function

    EFFECT function

    FV function

    IPMT function

    ISPMT function

    NOMINAL function

    PDURATION

    PMT function

    PPMT function

    PRICEMAT function

    RATE function

    Information

    CELL function

    ERROR.TYPE

    INFO function

    ISBLANK function

    ISERR function

    ISERROR function

    ISFORMULA [2013]

    ISLOGICAL

    ISNA function

    ISNONTEXT

    ISNUMBER function

    ISODD function

    ISREF function

    ISTEXT function

    N function

    NA function

    SHEET function

    SHEETS function

    TYPE function

    Logical

    AND function

    FALSE function

    IF function

    IFERROR function [2007]

    IFNA function [2013]

    IFS function [Office 365]

    NOT function

    OR function

    SWITCH function [2016]

    TRUE function

    XOR function [2013]

    Lookup and reference

    ADDRESS function

    AREAS function

    CHOOSE function

    COLUMN function

    COLUMNS function

    FORMULATEXT [2013]

    HLOOKUP function

    HYPERLINK

    INDEX function

    INDIRECT function

    LOOKUP function

    MATCH function

    OFFSET function

    ROW function

    ROWS function

    TRANSPOSE

    VLOOKUP function

    Math and trigonometry

    ABS function

    ACOS function

    ACOSH function

    ACOT function [2013]

    ACOTH function [2013]

    AGGREGATE

    ASIN function

    ASINH function

    ATAN function

    ATAN2 function

    ATANH function

    BASE function

    CEILING function

    COMBIN function

    COMBINA function [2013]

    COS function

    COSH function

    COT function [2013]

    COTH function [2013]

    CSC function

    DECIMAL function [2013]

    DEGREES function

    EVEN function

    EXP function

    FACT function

    FACTDOUBLE

    FLOOR.MATH [2013]

    FLOOR.PRECISE [2010]

    GCD function

    INT function

    LCM function

    LN function

    LOG function

    MINVERSE function

    MMULT function

    MOD function

    MROUND function

    MULTINOMIAL

    MUNIT function [2013]

    PI function

    POWER function

    PRODUCT function

    QUOTIENT function

    RADIANS function

    RAND function

    RANDBETWEEN

    SEC function

    SECH function

    SERIESSUM

    SIGN function

    SIN function

    SINH function

    SQRT function

    SUBTOTAL function

    SUM function

    SUMIF function

    SUMIFS function [2007]

    SUMPRODUCT

    SUMSQ function

    SUMX2MY2 function

    SUMX2PY2 function

    SUMXMY2 function

    TAN function

    TANH function

    TRUNC function

    Statistical

    AVEDEV function

    AVERAGE function

    AVERAGEA function

    AVERAGEIF [2007]

    AVERAGEIFS [2007]

    BETA.DIST [2010]

    BETA.INV function [2010]

    BINOM.DIST [2010]

    BINOM.INV [2010]

    CHISQ.DIST

    CHISQ.DIST.RT [2010]

    CHISQ.INV [2010]

    CHISQ.INV.RT [2010]

    CHISQ.TEST [2010]

    CONFIDENCE.NORM [2010]

    CONFIDENCE.T [2010]

    CORREL function

    COUNT function

    COUNTA function

    COUNTBLANK

    COUNTIF function

    COUNTIFS function [2007]

    COVARIANCE.P [2010]

    COVARIANCE.S [2010]

    EXPON.DIST [2010]

    EXPON.DIST [2010]

    F.DIST function [2010]

    F.DIST.RT [2010]

    FORECAST.LINEAR [2016]

    FREQUENCY

    GAMMA function [2013]

    GEOMEAN function

    GROWTH function

    LARGE function

    MAX function

    MAXIFS function [2016]

    MEDIAN function

    MIN function

    MINA function

    MINIFS function [2016]

    MODE.MULT [2010]

    MODE.SNGL [2010]

    NORM.DIST [2010]

    NORM.INV function [2010]

    PERMUT function

    PERMUTATIONA

    PHI function

    PROB function

    QUARTILE.INC [2010]

    RANK.AVG function [2010]

    RANK.EQ function [2010]

    SKEW function

    SLOPE function

    SMALL function

    STANDARDIZE

    STDEV.P function [2010]

    STDEV.S function [2010]

    STDEVA function

    STDEVPA function

    TREND function

    TRIMMEAN function

    VAR.P function [2010]

    VAR.S function [2010]

    Text

    ASC function

    CHAR function

    CLEAN function

    CODE function

    CONCAT function [Office 365]

    CONCATENATE

    EXACT function

    FIND function

    FIXED function

    LEFT function

    LEN function

    LOWER function

    MID function

    REPT function

    RIGHT function

    SEARCH function

    SUBSTITUTE

    T function

    TEXT function

    TEXTJOIN function [Office 365]

    TRIM function

    UPPER function

    VALUE function

    Web

    ENCODEURL [2013]

    WEBSERVICE [2013]




How to use the MAXIFS function

The MAXIFS function allows you to calculate the highest value based on a condition or criteria. Formula in cell G4: […]

Find latest date based on a condition

Table of contents Lookup a value and find max date How to enter an array formula Explaining array formula Download […]

Lookup min max values within a date range

This post demonstrates how to find minimum and maximum value using two conditions. In this case they are date conditions […]

      Formula categories

      Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup
  • Welcome! I am Oscar and here to help you out.

    Feel free to comment and ask Excel questions.

    Make sure you subscribe to my newsletter so you don't miss new blog articles.

  • Free Blog Emails

    Get a free PDF book!

  • Search website