I am trying to write a formula to return a count if cell a1 equals "value a"
and cell a2 is not blank. I have tried various combinations of countif,
if(and..., counta, and count formulas with no success! Can anyone assist me
with creating a formula?

Thanks-
Michele