Hi,
I would like to use countifs to count all not blank entries in column A that are also not blank in column B. Column B contains formulas, so I want to avoid counting blanks cells that have a formula in them.
I'm comfortable using countifs, but basically I can't find the syntax to say [countif not blank (unless a blank cell has a formula, in which case count that as blank)]
Many thanks for any help
Bookmarks