Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

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

      • Wobzy
    3. Replies
      3
      Views
      685
      3

    4. AliGW

    2. COUNTIFS on Table and Between Dates 3

      • dloc_26
    3. Replies
      3
      Views
      821
      3

    4. Fluff13

    2. countifs not counting date values when copied 1

      • bus9892
    3. Replies
      1
      Views
      213
      1

    4. bus9892

    2. Countifs miscalculates date and time criteria 9

      • udhaya_k
    3. Replies
      9
      Views
      1.1k
      9

    4. AliGW

    2. CountIFS in same row problem 2

      • jbanks
    3. Replies
      2
      Views
      668
      2

    4. rory

    2. Countifs formula using A:A or A2:A1000 4

      • cobber1418
    3. Replies
      4
      Views
      1k
      4

    4. cobber1418

    2. Countifs formula to only count 'Last month' 5

      • cobber1418
    3. Replies
      5
      Views
      550
      5

    4. royUK

    2. COUNTIFS Formula Not Counting "1/0/1900" Date 1

      • JAMIEPACHOMSKI
    3. Replies
      1
      Views
      293
      1

    4. Pecoflyer

    2. Countifs does not give desired results 7

      • rabsofty
    3. Replies
      7
      Views
      817
      7

    4. rabsofty

    2. Countifs date formula 14

      • cobber1418
    3. Replies
      14
      Views
      1.9k
      14

    4. royUK

    2. Countif, Index, Match Indirect

      • Kumar Chandra
    3. Replies
      0
      Views
      222

    2. Countif, finding unique or duplicate records in two different sheets, each containing just one column of numbers 1

      • etb
      • etb
    3. Replies
      1
      Views
      431
      1

    4. etb

    2. Countif with Index and Match 1

      • A3Eigelaar
    3. Replies
      1
      Views
      1.3k
      1

    4. Ger Plante

    2. Countif while ignoring everything after character 4

      • svenn
    3. Replies
      4
      Views
      658
      4

    4. svenn

    2. countif using input cell as range depth 5

      • 1legin
    3. Replies
      5
      Views
      867
      5

    4. 1legin

    2. COUNTIF Problem 16

      • endl3ss
    3. Replies
      16
      Views
      2.3k
      16

    4. AliGW

    2. Countif or Array Formula 3

      • aussiformula
    3. Replies
      3
      Views
      1.5k
      3

    4. crushdrinker06

    2. Countif not working 6

      • eureka18
    3. Replies
      6
      Views
      1.1k
      6

    4. Carim

    2. CountIf Multiple Columns per Rows 9

      • mrbuttons
    3. Replies
      9
      Views
      1.7k
      9

    4. royUK

    2. Countif issue after applying formulas and overwriting with values 3

      • Box Jockey
    3. Replies
      3
      Views
      636
      3

    4. Box Jockey

Label

Display Options