ExcelBanter - COUNTIF

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - COUNTIF (https://www.excelbanter.com/excel-discussion-misc-queries/132189-countif.html)

Tufail

COUNTIF

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

COUNTIF

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.

Tufail

COUNTIF

it's working ! thank you very much.

"Toppers" wrote:

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.

All times are GMT +1. The time now is 01:31 PM.