Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • Wobzy
    2. Replies
      3
      Views
      685
      3
    3. AliGW

    1. COUNTIFS on Table and Between Dates 3

      • dloc_26
    2. Replies
      3
      Views
      821
      3
    3. Fluff13

    1. countifs not counting date values when copied 1

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

    1. Countifs miscalculates date and time criteria 9

      • udhaya_k
    2. Replies
      9
      Views
      1.1k
      9
    3. AliGW

    1. CountIFS in same row problem 2

      • jbanks
    2. Replies
      2
      Views
      668
      2
    3. rory

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

      • cobber1418
    2. Replies
      4
      Views
      1k
      4
    3. cobber1418

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

      • cobber1418
    2. Replies
      5
      Views
      550
      5
    3. royUK

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

      • JAMIEPACHOMSKI
    2. Replies
      1
      Views
      293
      1
    3. Pecoflyer

    1. Countifs does not give desired results 7

      • rabsofty
    2. Replies
      7
      Views
      817
      7
    3. rabsofty

    1. Countifs date formula 14

      • cobber1418
    2. Replies
      14
      Views
      1.9k
      14
    3. royUK

    1. Countif, Index, Match Indirect

      • Kumar Chandra
    2. Replies
      0
      Views
      222
    1. Countif, finding unique or duplicate records in two different sheets, each containing just one column of numbers 1

      • etb
      • etb
    2. Replies
      1
      Views
      431
      1
    3. etb

    1. Countif with Index and Match 1

      • A3Eigelaar
    2. Replies
      1
      Views
      1.3k
      1
    3. Ger Plante

    1. Countif while ignoring everything after character 4

      • svenn
    2. Replies
      4
      Views
      658
      4
    3. svenn

    1. countif using input cell as range depth 5

      • 1legin
    2. Replies
      5
      Views
      867
      5
    3. 1legin

    1. COUNTIF Problem 16

      • endl3ss
    2. Replies
      16
      Views
      2.3k
      16
    3. AliGW

    1. Countif or Array Formula 3

      • aussiformula
    2. Replies
      3
      Views
      1.5k
      3
    3. crushdrinker06

    1. Countif not working 6

      • eureka18
    2. Replies
      6
      Views
      1.1k
      6
    3. Carim

    1. CountIf Multiple Columns per Rows 9

      • mrbuttons
    2. Replies
      9
      Views
      1.7k
      9
    3. royUK

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

      • Box Jockey
    2. Replies
      3
      Views
      636
      3
    3. Box Jockey

Label

Display Options