Try:

=SUMPRODUCT(($A$1:$A$5<"")*($B$1:$B$5=""))

Column A is non-blank (text/number)

"Tufail" wrote:

hi
i want count my data like is as under:

count if cell A1 has some value (text) and B1 is blank.

thanks in advance.