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

    Basic formulas


    Count

    Pattern in cell value

    Cells with text values

    Rows containing data

    Cells equal list values

    Containing any list value


    Dates

    Weekdays in date range

    Days between 2 dates

    Sum between two dates

    Overlapping ranges


    Extract

    K-th word in cell value

    Numbers in cell value

    Last word in cell value

    First word in cell value

    First three digits in value


    Index match

    Critera - multiple results

    Case sensitive

    Multiple results

    Multiple conditions


    Logic

    If cell has value

    If cell contains any text

    Cell contains list value

    Cells equal to list value

    Cell contains list value

    If cell contains text

    Multiple conditions

    IF & AND - Conditions

    Nested IF functions


    Lookups

    Two-dimensional lookup


    Text string manipulation

    Replace part of formula


    Sum

    Sum by group

    Sum between two dates

    Running totals


    Time

    How to AVERAGE time

    Overlapping ranges




Sum


Excel » Basic formulas » Sum »

Sum by group

To extract groups from cell range B3:B10 I use the following regular formula in cell B13.

Sum between two dates

The formula in cell C15 uses two dates two to filter and then sum values in column C, the SUMIFS […]

Running totals

The SUM function in cell D3 uses only a single cell reference and still manages to sum current and previous […]

      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