I need to code some stuff in Excel before I import it into Access... I can
code vb in Access but get mixed up in Excel:

I want to insert a formula in a cell, but it doesn't like the parens around
unit summary:

Range("O1").Formula = "=COUNTA(A13:A100) -COUNTIF(E13:E100,"Unit Summary")"

Seemed like there were other examples on this site of using "" in a formula
or value? I tried no parens (returns 0 for countif) and tried '. Thx