Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Adding a range of cells based on addressing from a match 1

      • oddcarout
    2. Replies
      1
      Views
      521
      1
    3. skywriter

    1. Time Sheet Formula 5

      • scarlett_b
    2. Replies
      5
      Views
      1k
      5
    3. scarlett_b

    1. Calculate average for specified numbers from a column 4

      • Mike91
    2. Replies
      4
      Views
      1k
      4
    3. S O

    1. Merge / Combine cell range into single cell with line break 2

      • Elusive
    2. Replies
      2
      Views
      1.2k
      2
    3. cytop

    1. Formula to update a cell date systematically 2

      • RNF
      • RNF
    2. Replies
      2
      Views
      656
      2
    3. sktneer

    1. vlookup cell values only if date on adjacent column less than requested. INDEX/MATCH? 9

      • Elusive
    2. Replies
      9
      Views
      1.8k
      9
    3. sktneer

    1. Payroll timesheet with complex payrate structure needing formula variation 1

      • AussieNat
    2. Replies
      1
      Views
      821
      1
    3. ansonsia

    1. Prevent Duplicate in Drop Down List 1

      • kapil.raj1985
    2. Replies
      1
      Views
      1.4k
      1
    3. pike

    1. I am trying to do Countifs with multiple criteria and an array 2

      • pat1009
    2. Replies
      2
      Views
      812
      2
    3. pike

    1. Match Values on two worksheets by matching names 2

      • Static Electric
    2. Replies
      2
      Views
      749
      2
    3. Static Electric

    1. Today() does not stay should lock,but change when open the next day 4

      • rooky1
    2. Replies
      4
      Views
      768
      4
    3. rooky1

    1. Multiplying a number betwee ranges in an IF statement 1

      • MichelleY16
    2. Replies
      1
      Views
      671
      1
    3. NBVC

    1. Taken taken minus breaks over midnight 4

      • Static Cat
    2. Replies
      4
      Views
      1.3k
      4
    3. Batman

    1. Return Specific Value from adjacent cell if values match 5

      • JadeRae
    2. Replies
      5
      Views
      2.3k
      5
    3. skywriter

    1. I keep getting #Name? for the answer to the cell. 3

      • blade671
    2. Replies
      3
      Views
      760
      3
    3. norie

    1. IF statement uisng index match 3

      • makp
    2. Replies
      3
      Views
      769
      3
    3. NBVC

    1. Trying to pull specific data from sheet1 to other sheets if it meets criteria 10

      • blade671
    2. Replies
      10
      Views
      1.7k
      10
    3. blade671

    1. Vlookup using tabs with specific cell reference 2

      • wosborne
    2. Replies
      2
      Views
      830
      2
    3. wosborne

    1. Calculate total hours worked on an oddly organized timesheet 4

      • APreston
    2. Replies
      4
      Views
      1.3k
      4
    3. APreston

    1. inventory worksheet HELP! 6

      • ANoard92
    2. Replies
      6
      Views
      1.2k
      6
    3. royUK

Display Options