Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Sum row from 1 worksheet if information matches data in column of another worksheet 3

      • EZBreathe-Sarah
    2. Replies
      3
      Views
      160
      3
    3. royUK

    1. Show maximum value with condition 9

      • matyldk
    2. Replies
      9
      Views
      248
      9
    3. royUK

    1. Count number of consecutive values after 3rd occurrence 1

      • MegOzam
    2. Replies
      1
      Views
      112
      1
    3. royUK

    1. Problem with COUNTIFS formula, dosnt show proper results 6

      • matyldk
    2. Replies
      6
      Views
      236
      6
    3. matyldk

    1. Fomula required to calculate and summarise qty's between a start and finish date 3

      • Freddyfroo
    2. Replies
      3
      Views
      165
      3
    3. Freddyfroo

    1. Automatically enter data into a cell based on another's cell value 2

      • VWRSue
    2. Replies
      2
      Views
      500
      2
    3. audreyvega

    1. Match Columns across sheet and Return adjacent cell value 2

      • pranavk
    2. Replies
      2
      Views
      268
      2
    3. pranavk

    1. Using sumif on different columns without getting a double/triple sum up 3

      • thenoobishamateur
    2. Replies
      3
      Views
      172
      3
    3. thenoobishamateur

    1. return a value based on multiple table references 2

      • dsmessenger
    2. Replies
      2
      Views
      180
      2
    3. dsmessenger

    1. Medain if formula not working 3

      • brin1980
    2. Replies
      3
      Views
      266
      3
    3. Fluff13

    1. Copy entire row to another sheet if value matches 10

      • passer_by
    2. Replies
      10
      Views
      498
      10
    3. royUK

    1. Combining Text Data from multiple rows to one row 2

      • paulmcphillimy
    2. Replies
      2
      Views
      217
      2
    3. paulmcphillimy

    1. MOD(ROWS() Function 6

      • Garth Lean
    2. Replies
      6
      Views
      328
      6
    3. royUK

    1. Index match #REF! error 7

      • dsmessenger
    2. Replies
      7
      Views
      834
      7
    3. Fluff13

    1. copy formula 2

      • guscy
    2. Replies
      2
      Views
      598
      2
    3. royUK

    1. Get Header data and row/column data value 4

      • IGACICI
    2. Replies
      4
      Views
      542
      4
    3. IGACICI

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

      • browncoat
    2. Replies
      6
      Views
      464
      6
    3. browncoat

    1. Extract unique values based on multiple criteria 2

      • hafizt
    2. Replies
      2
      Views
      330
      2
    3. hafizt

    1. How to get total days which it is Reported Date - Actual Finish? 2

      • Xani
      • Xani
    2. Replies
      2
      Views
      186
      2
    3. sobi_256

    1. Calculating minimum and maximum Price with different units 5

      • onexc
    2. Replies
      5
      Views
      368
      5
    3. royUK

Display Options