Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Sumproduct with blank criteria 7

      • DaneMark
    2. Replies
      7
      Views
      1.7k
      7
    3. XOR LX

    1. Conditional Formatting Formula 2

      • brandybartz
    2. Replies
      2
      Views
      632
      2
    3. sktneer

    1. SUMIF Using Dynamic Ranges based on text similarities 5

      • endl3ss
    2. Replies
      5
      Views
      1k
      5
    3. NBVC

    1. SUMIF Totals based on multiple critertia 7

      • amanda0210
    2. Replies
      7
      Views
      1k
      7
    3. amanda0210

    1. Count of unique name and date of birth matches 6

      • QAM
      • QAM
    2. Replies
      6
      Views
      1.2k
      6
    3. QAM

    1. move cell values in Description from colums onto the same row based on a key 2

      • Daidin
    2. Replies
      2
      Views
      772
      2
    3. sktneer

    1. Tips on getting around length limits for formulas? 2

      • ivorykeys87
    2. Replies
      2
      Views
      647
      2
    3. AliGW

    1. Auto Number +1 from text, if duplicate text not increase 3

      • johnreid7477
    2. Replies
      3
      Views
      912
      3
    3. AliGW

    1. Use Hlookup to find then sum column within specific dates 1

      • merz
      • merz
    2. Replies
      1
      Views
      781
      1
    3. merz

    1. Convert Decimal To Text in Fraction format 1

      • JohnDrew
    2. Replies
      1
      Views
      767
      1
    3. rory

    1. Comparing VLOOKUP speeds versus straight calculations 2

      • MathemAddicts
    2. Replies
      2
      Views
      1.3k
      2
    3. MathemAddicts

    1. Counting the frequency of a specific number on a specific day 2

      • M Edwards
    2. Replies
      2
      Views
      722
      2
    3. M Edwards

    1. Contiguous Weighted Average Excluding Zeroes 2

      • gc052
    2. Replies
      2
      Views
      786
      2
    3. gc052

    1. An array excel formula to increase the numebrs in the array bracket 3

      • sarah81
    2. Replies
      3
      Views
      765
      3
    3. NBVC

    1. Sum if with 2 conditions 1

      • eurano
    2. Replies
      1
      Views
      616
      1
    3. NBVC

    1. Excel formula err lookup 1

      • libin baby
    2. Replies
      1
      Views
      711
      1
    3. NBVC

    1. Sumproduct and mid function 1

      • eurano
    2. Replies
      1
      Views
      740
      1
    3. NBVC

    1. Using a value from a cell inside a formula 8

      • yogeshtalks
    2. Replies
      8
      Views
      1.8k
      8
    3. NBVC

    1. VLOOKUP does not return the correct values 1

    2. Replies
      1
      Views
      835
      1
    3. crushdrinker06

    1. Help to determine top sales person 5

      • Hoowzer
    2. Replies
      5
      Views
      1.2k
      5
    3. Hoowzer

Display Options