Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Averaging both positive and negative numbers 9

      • caldog
    2. Replies
      9
      Views
      965
      9
    3. Carim

    1. Getting value of the latest date based on criteria 2

      • cakzprimz
    2. Replies
      2
      Views
      544
      2
    3. Carim

    1. If Formular calculating 2 items 3

      • byga85
    2. Replies
      3
      Views
      297
      3
    3. Carim

    1. VLookup on specific tab names 2

      • bwkisley
    2. Replies
      2
      Views
      599
      2
    3. bwkisley

    1. Link a Cell to a Picture?? 6

      • bwkisley
    2. Replies
      6
      Views
      1k
      6
    3. bwkisley

    1. Dependent Drop Down List 9

      • busybee_1_in
    2. Replies
      9
      Views
      1.1k
      9
    3. Carim

    1. Drop Down List based on last used row 3

      • busybee_1_in
    2. Replies
      3
      Views
      520
      3
    3. royUK

    1. countifs not counting date values when copied 1

      • bus9892
    2. Replies
      1
      Views
      206
      1
    3. bus9892

    1. Sum a value if its Date is within 90 days of each Month shown in second table 6

      • burdenpi
    2. Replies
      6
      Views
      748
      6
    3. Logit

    1. Identify highest score category within group 3

      • bunty_1244
    2. Replies
      3
      Views
      581
      3
    3. AliGW

    1. Dynamic Named range counting "" in data range 1

      • BScott05
    2. Replies
      1
      Views
      767
      1
    3. skywriter

    1. Extracting long format Month from Today() 1

      • Bryan021
    2. Replies
      1
      Views
      459
      1
    3. Infomage

    1. Countif compound criteria? 3

      • Bryan021
    2. Replies
      3
      Views
      619
      3
    3. NBVC

    1. Erroneous #NAME? error that goes away when I drag the formula back over the cells showing the error 1

      • browncoat
    2. Replies
      1
      Views
      279
      1
    3. royUK

    1. Is it possible to have the user type a formula into a cell and have it treated as text so that other cells can incorporate that into their formula? 8

      • browncoat
    2. Replies
      8
      Views
      697
      8
    3. Carim

    1. AVERAGEIF a range of cells based on a specific value in adjacent cell but ignore empty cells? 6

      • browncoat
    2. Replies
      6
      Views
      1.1k
      6
    3. browncoat

    1. Matching blank cells in SUMIFs with multiple criteria 2

      • browncoat
    2. Replies
      2
      Views
      1k
      2
    3. browncoat

    1. xlookup multiple criteria? 2

      • browncoat
    2. Replies
      2
      Views
      2.1k
      2
    3. gyankosh.net

    1. Complicated Ranking based off of multiple conditions 8

      • broman5000
    2. Replies
      8
      Views
      747
      8
    3. broman5000

    1. PROMPTLY. help repair a corrupted Excel file (2003 release version) 1

      • brioche
    2. Replies
      1
      Views
      253
      1
    3. AliGW

Label

Display Options