Excel Formulas

Questions related specifically to the use of Excel formulas.

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

Mark All as Read

    2. Sumproduct and mid function 1

      • eurano
    3. Replies
      1
      Views
      948
      1

    4. NBVC

    2. Sumproduct by Date Value 3

      • mar050703
    3. Replies
      3
      Views
      1.1k
      3

    4. 63falcondude

    2. SUMPRODUCT even with #N/A values (2 dimensional sumproduct formulae) 5

      • HestiA
    3. Replies
      5
      Views
      808
      5

    4. KjBox

    2. SumProduct fails to accept "*" 4

      • duburns
    3. Replies
      4
      Views
      737
      4

    4. NBVC

    2. SUMPRODUCT on 1 column and criteria on another columns

      • richardd8x
    3. Replies
      0
      Views
      255

    2. SUMPRODUCT One of the best formulas in Excel 1

      • gregh
    3. Replies
      1
      Views
      525
      1

    4. alansidman

    2. Sumproduct or Sumif with Indirect Function for external data source 2

      • railfan
    3. Replies
      2
      Views
      1.5k
      2

    4. Carim

    2. SUMPRODUCT over dynamic range - No VBA 1

      • al4xms
    3. Replies
      1
      Views
      956
      1

    4. AliGW

    2. SUMPRODUCT Partial Match - #N/A 1

      • Desauv
    3. Replies
      1
      Views
      673
      1

    4. pike

    2. SUMPRODUCT to count Within Time Range 2

      • svenn
    3. Replies
      2
      Views
      187
      2

    4. svenn

    2. Sumproduct with 'text' dropdown 1

      • mikem21788
    3. Replies
      1
      Views
      1.1k
      1

    4. pike

    2. Sumproduct with blank criteria 7

      • DaneMark
    3. Replies
      7
      Views
      2.3k
      7

    4. XOR LX

    2. Syntax error in formula 5

      • FrankM
    3. Replies
      5
      Views
      668
      5

    4. FrankM

    2. Syntax help - SUMIF Formula 3

      • cutestuff
    3. Replies
      3
      Views
      642
      3

    4. Niraj

    2. syntax of excel formula withindirect 4

      • arlener
    3. Replies
      4
      Views
      537
      4

    4. arlener

    2. Taken taken minus breaks over midnight 4

      • Static Cat
    3. Replies
      4
      Views
      2k
      4

    4. Batman

    2. Taking First Letter from Each Word 4

      • VeraSidika
    3. Replies
      4
      Views
      1.8k
      4

    4. Carim

    2. Teammates can’t match up in 3 consecutive days

      • Golfnut1
    3. Replies
      0
      Views
      175

    2. Test to columns help please 4

      • Elso1959
    3. Replies
      4
      Views
      405
      4

    4. Estevaoba

    2. Text extraction and searchable data validation list 4

      • nmkhan3010
    3. Replies
      4
      Views
      1.1k
      4

    4. nmkhan3010

Label

Display Options