Hi Michele

one option
=SUMPRODUCT(--(A1="a"),--(A2<""))

check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

for details on how this function works
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Michele" wrote in message
...
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