Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. SUMIFS or SUMPRODUCT both returning #VALUE error 2

      • DezB
      • DezB
    3. Replies
      2
      Views
      180
      2

    4. Carim

    2. Conditional Formatting to highlight column based on date in row 5

      • DezB
      • DezB
    3. Replies
      5
      Views
      268
      5

    4. Carim

    2. How to create Conditional Formatting with a range of dates? 4

      • GradB
    3. Replies
      4
      Views
      193
      4

    4. Carim

    2. Count values on a row that are within, equal to or greater than a value in row within the same column 4

      • Shezmo1
    3. Replies
      4
      Views
      676
      4

    4. Carim

    2. Pivot Table with a filter that displays a SUM of Total with a specific number or numbers 12

      • PETRODATAjames
    3. Replies
      12
      Views
      949
      12

    4. PETRODATAjames

    2. INDEX/MATCH Formula - beyond me 11

      • DezB
      • DezB
    3. Replies
      11
      Views
      287
      11

    4. Carim

    2. Find matching string and get string of data in offset cell from raw dataset 15

      • robystar
    3. Replies
      15
      Views
      803
      15

    4. Carim

    2. How to identify leaders? 9

      • GradB
    3. Replies
      9
      Views
      462
      9

    4. Carim

    2. Calculate the date between to cells 5

      • PETRODATAjames
    3. Replies
      5
      Views
      704
      5

    4. PETRODATAjames

    2. Formula with cap 10

      • DANGPS
    3. Replies
      10
      Views
      369
      10

    4. DANGPS

    2. Date in Excel if it is a Working Day 3

      • skamat
    3. Replies
      3
      Views
      232
      3

    4. Carim

    2. Hourly Payroll Template 9

      • PETRODATAjames
    3. Replies
      9
      Views
      593
      9

    4. Carim

    2. Payroll worksheet with VLOOKUP issues 18

      • PETRODATAjames
    3. Replies
      18
      Views
      567
      18

    4. Carim

    2. Predefined text in a cell 4

      • Allround_IT_er
    3. Replies
      4
      Views
      289
      4

    4. Carim

    2. Adding one more variable to an IF statement Formula 6

      • SkateRockandRoll
    3. Replies
      6
      Views
      357
      6

    4. Carim

    2. Need help to correct the error in the formula 2

      • RAJESH SHAH
    3. Replies
      2
      Views
      138
      2

    4. RAJESH SHAH

    2. NPER with daily compounding interest? 6

      • jronaldlee
    3. Replies
      6
      Views
      260
      6

    4. Carim

    2. Calculating a level 2

      • Kyp
      • Kyp
    3. Replies
      2
      Views
      264
      2

    4. Carim

    2. Select Odd Rows from Named Range 21

      • Cobstillaware
    3. Replies
      21
      Views
      2k
      21

    4. Carim

    2. VLOOKUP or something else 6

      • caper1965
    3. Replies
      6
      Views
      419
      6

    4. Carim

Label

Display Options