COUNTIF

Tufail · Feb 24, 2007

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.

Toppers · Feb 24, 2007

Try:

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

Column A is non-blank (text/number)

Tufail · Feb 24, 2007

it's working ! thank you very much.

Toppers said:
Try:

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

Column A is non-blank (text/number)