Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Using Address() in a logical test 3

      • OceanRoaming
    2. Replies
      3
      Views
      973
      3
    3. OceanRoaming

    1. Using Cell Content As Input to a Structured Reference 2

      • thefatstig
    2. Replies
      2
      Views
      438
      2
    3. pike

    1. Using Countif to calculate totals from another excel tab 1

      • Xani
      • Xani
    2. Replies
      1
      Views
      234
      1
    3. alansidman

    1. Using COUNTIFS to try to count records between two dates 5

      • cthompson73
    2. Replies
      5
      Views
      402
      5
    3. royUK

    1. Using dropdowns to copy cells from one worksheet to corresponding cells of another worksheet and add new rows if needed. 4

      • CNeedsHelp
    2. Replies
      4
      Views
      816
      4
    3. royUK

    1. Using IF, AND, OR 3

    2. Replies
      3
      Views
      1.3k
      3
    3. skywriter

    1. Using index and match in the right way 2

      • MihaiBanciu
    2. Replies
      2
      Views
      456
      2
    3. Niraj

    1. Using INDIRECT in the Formula That Defines a Graph's Data Range 10

      • OldFella
    2. Replies
      10
      Views
      7k
      10
    3. Carim

    1. using INDIRECT to set structured table reference in formula and return COUNTIF result based on another column value 2

      • alz1
      • alz1
    2. Replies
      2
      Views
      446
      2
    3. alz1

    1. Using of VLOOKUP and ISNUMBER 8

      • onexc
    2. Replies
      8
      Views
      9.7k
      8
    3. KjBox

    1. Using SUBTOTAL formula within an IF formula 2

      • davec0864
    2. Replies
      2
      Views
      257
      2
    3. GlennUK

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

      • thenoobishamateur
    2. Replies
      3
      Views
      696
      3
    3. thenoobishamateur

    1. Using sumproduct to sum values associated with years 8

      • riskier4ra
    2. Replies
      8
      Views
      1.4k
      8
    3. Tom.Jones

    1. Using TODAY function in a VLOOKUP formula 3

      • Shezmo1
    2. Replies
      3
      Views
      468
      3
    3. Carim

    1. Using wildcard in conditional formula not working 3

      • Billyrj
    2. Replies
      3
      Views
      935
      3
    3. royUK

    1. V and H Lookups On Dynamic Data 8

      • abba92
    2. Replies
      8
      Views
      1.1k
      8
    3. markdininn

    1. Vacation entitlement calculation 3

      • myexcelstar
    2. Replies
      3
      Views
      617
      3
    3. gijsmo

    1. Validating for Weekday Date OR Text 2

      • jzehr
    2. Replies
      2
      Views
      931
      2
    3. jzehr

    1. Validation Between 2 Sheets

      • mzukowsk
    2. Replies
      0
      Views
      140
    1. Validation List using a Table 3

      • mar050703
    2. Replies
      3
      Views
      445
      3
    3. royUK

Label

Display Options