Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. COUNTIFS or SUMPRODUCT? Match criteria if other criteria is met. 3

      • Wobzy
    3. Replies
      3
      Views
      638
      3

    4. AliGW

    2. Find a sum based on a date range and an aditional value 3

      • avb85
    3. Replies
      3
      Views
      593
      3

    4. Carim

    2. Filling a column with text values extracted from another sheet 2

      • mystie
    3. Replies
      2
      Views
      551
      2

    4. mystie

    2. Formula/VLOOKUP for multiple 'greater than' criteria to return multiple results 2

      • cm882653
    3. Replies
      2
      Views
      443
      2

    4. cm882653

    2. WEEKDAYNAME function not working... error #NAME? (Excel 2013) 1

      • Dougmeister
    3. Replies
      1
      Views
      824
      1

    4. NBVC

    2. "tilde" in vlookup formula 13

      • Anri
      • Anri
    3. Replies
      13
      Views
      3.3k
      13

    4. Carim

    2. Date wise sum of value 7

      • makhdoomliaqat
    3. Replies
      7
      Views
      1.2k
      7

    4. Carim

    2. IF AND OR statement 4

      • 3ball
    3. Replies
      4
      Views
      705
      4

    4. Trebor76

    2. Transfering data 3

      • kennethbrandon
    3. Replies
      3
      Views
      874
      3

    4. alansidman

    2. Formula for adding previous sheets 2

      • jberena
    3. Replies
      2
      Views
      456
      2

    4. royUK

    2. greater than less that plus add 3

      • Hoops
    3. Replies
      3
      Views
      705
      3

    4. pike

    2. Formula for Extraciting the Year from the Date Column in a Table 2

      • mar050703
    3. Replies
      2
      Views
      527
      2

    4. mar050703

    2. Double counting in SUMPRODUCT formula 11

      • Luis Ah-Hoy Jr.
    3. Replies
      11
      Views
      1.9k
      11

    4. Luis Ah-Hoy Jr.

    2. iserror and isblank formula use both in one formula 2

      • krpatel
    3. Replies
      2
      Views
      975
      2

    4. NBVC

    2. Auto numbering 2

      • kennethbrandon
    3. Replies
      2
      Views
      675
      2

    4. kennethbrandon

    2. vlookup formula with isblank or iserror formula 1

      • krpatel
    3. Replies
      1
      Views
      655
      1

    4. NBVC

    2. match or vlookup for filling data 1

      • andrej
    3. Replies
      1
      Views
      619
      1

    4. NBVC

    2. Search Cell for Specific Characters 3

      • Yeppy12
    3. Replies
      3
      Views
      663
      3

    4. Yeppy12

    2. Combining text in a cell that has the same number in a adjacent cell 3

      • JezzaS
    3. Replies
      3
      Views
      610
      3

    4. pike

    2. If a Cell Contains a Certain Text (From Another Table) 3

      • Bisso
    3. Replies
      3
      Views
      581
      3

    4. Carim

Label

Display Options